Hi,
I am trying to put a picture in the header on an excel document and align the image so that it goes all the way to the top edge of the page. I can not get rid of about a half inch of white space above the header. Header margin is set to 0"
Here is the section of code I am using to put the image in the header and move it up to the top of the page.
For Each sht In Sheets
sht.PageSetup.LeftHeaderPicture.Filename = "H:\pic1.jpg"
sht.PageSetup.LeftHeaderPicture.CropTop = 50
sht.PageSetup.LeftHeader = "&G"
Next sht
I am trying to put a picture in the header on an excel document and align the image so that it goes all the way to the top edge of the page. I can not get rid of about a half inch of white space above the header. Header margin is set to 0"
Here is the section of code I am using to put the image in the header and move it up to the top of the page.
For Each sht In Sheets
sht.PageSetup.LeftHeaderPicture.Filename = "H:\pic1.jpg"
sht.PageSetup.LeftHeaderPicture.CropTop = 50
sht.PageSetup.LeftHeader = "&G"
Next sht