If you want to make the macro a little more generalized
you could have your headers and footers as you want them
for the rest of the sheets then have the macro save the
header/footer parts you want to change and then restore
them after printing the first page. (in Ron's macro)
If you wanted to do first page differently with respect to headers,
such as with or without a logo
or no header rows you can do that by using the top rows of
the spreadsheet and doing the rows to repeat later on. And
forcing the page break just before your rows to repeat. http://www.mvps.org/dmcritchie/excel/logoshd.htm#toprows
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.