Footers

[cdefiora]

How can I get a different footer to appear on the last
page only?
Thank you for any help you can provide.

 

[David McRitchie]

You would have to start the printer twice, once without the
last page, and once with only the last page. You can use
a macro to do that. And you would have to change the
footer in between printings.

 

[David McRitchie]

For more information including how to find the number of pages in a worksheet and how
to change the header or footer from page to page, see
http://google.com/[email protected]
and a bunch of related issues:
http://google.com/groups?threadm=e4FqF7hvCHA.2600@TK2MSFTNGP11

Directions to install and use a macro on my getstarted.htm web page.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

You would have to start the printer twice, once without the
last page, and once with only the last page. You can use
a macro to do that. And you would have to change the
footer in between printings.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

How can I get a different footer to appear on the last
page only?
Thank you for any help you can provide.