Jac
See Ron de Bruin's site for code.
http://www.rondebruin.nl/print.htm#Header
Gord Dibben MS Excel MVP
On Sat, 20 Jan 2007 19:33:33 -0800, 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