I am trying to insert a picture in a header of an Excel File. It is clear to me how to do it from a local file in the hard disk, what I can not figure it out is:
if the picture is one in a sheet from the same Workbook, as example:
ActiveSheet.PageSetup.RightHeaderPicture = Sheets("datasheet").Shapes.Range(Array("myLogo")) With ActiveSheet.PageSetup .RightHeader = "&G" End With
can anyone help me to figure it out?
thanks in advance for your support