Headers and Footers

[SummerSplash]

Is it possible to have a different header or footer on the first page of an Excel 2000 document than you have on subsequent pages? If this is possible, please let me know how it works. Any help will be greatly appreciated.

[nerakay]

I assume you've already considered multiple sheets - which allowing different headers for each sheet?

[SummerSplash]

Thanks for your speedy response. Yes multiple sheets have been considered, but the user of this document does not wish to split his document. It will be edited and changed often, thus the end of the first page will also change frequently.

[Leif]

How about a macro that sets the footer and prints page one, then changes the footer and prints pages 2-n ?
(I pretty sure n can be a much greater number than the actual number of pages without an error.)

[capri]

If you don't mind the extra work of having to put a header on each page, why not use custom headers. When I use them, I just copy on that I want to repeat on several pages and paste it, but it allows me to have different ones or even a page or two with none.