PageSetup.RightHeaderPicture (Excel)
Returns a Graphic object that represents the picture for the right section of the header. Used to set attributes about the picture.
The RightHeaderPicture property is read-only, but not all of its properties are read-only. It is required that "&G" be a part of the RightHeader property string for the image to show up in the right header.
Dim grpRightHeaderPicture As Graphic
Set grpRightHeaderPicture = Worksheets("Sheet1").PageSetup.RightHeaderPicture