"What-A-Tool" wrote in message
...
Sorry - lost my original post _

Have a macro that creates a workbook, copies som sheets from various other
books, then loops thru all sheets, creating a header fro each.
For some unknown reason, my header is only appearing in about half of my
sheets, even tough my procedure is hitting and running the following code
for each sheet in my book,
I have run this code on other books and it seems to work.



Simple solution that for some reason just wasn't registering !
The sheets that my header wasn't showing up on had a TOP MARGIN of .5in
The sheets that it was working on had a TOP MARGIN of 1.25in
All works fine with a simple edition to my AddHeader Procedure :

sht.PageSetup.TopMargin = Application.InchesToPoints(1.25)

Thanks Tom and Jim for taking the time to try and help - Sean