I want to put a different header on each page. I want to use consecutive
dates, excluding weekends as headers on each page.

"each page" of a multi-page print-out?

You will have to run separate print jobs for each page.

You could do it with VBA code but would still result in multiple print jobs.

See Ron de Bruin's site for some code which you could adapt to suit.

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP


On Thu, 9 Oct 2008 13:04:12 -0700, suicidecity
wrote:

I want to put a different header on each page. I want to use consecutive
dates, excluding weekends as headers on each page.