"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.


The strange thing is, when I PRINT PREVIEW, and click SETUP, then click the
HEADER/FOOTER tab, the correct header is displayed, even for the sheets that
don't display it in PRINT PREVIEW. (It doesn't print on hard copies, either)