Overlapping image in sheet header

[ryancgarrett]

Sorry, lot's of questions lately, I just started a new job that is requiring a lot more VBA than I have used in a while and I need to brush up.

I'm creating a customer statement and have the company logo in the sheet header. The logo is large and overlaps the first 8 rows of the page (which is fine). I would however, like to not show those rows so that if someone was to look at the spreadsheet in "Normal" where they can't see the header, it wouldn't just be 8 blank rows. I tried hiding the rows but that just cause my statement to overlap the logo.

Any suggestions?

 

[pgc01]

Hi

Instead of having the picture overlapping the first rows of the statement increase the header height so that it includes the whole picture.
The statement should in this case start at row 1.

In the print preview you'll have the picture in the header, not overlapping the statement, but in normal view you'll have the statement starting at row 1 as usual.

HTH