Thread: Printing Headers on only first page and Footers on only last page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JacMar JacMar is offline
external usenet poster
  
Posts: 12
Default Printing Headers on only first page and Footers on only last page


"JacMar" wrote:

I'm controlling the printing of a sheet of various lenght with a macro. How
do I ensure that the Header only prints on the first page, and the Footer
only on the last page. The pages will vary from one to three or four. . .
. or should I use something else than Headers and Footers?

Thank you

Sorry, I forgot to mention I am using Excel 2002.
Reply With QuoteReply With Quote