Footers

C

cdefiora

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

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.
 
D

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/groups?threadm=qlei5sge6klek1j6bj78ti3m9f716qdqeg@4ax.com
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

David McRitchie said:
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

cdefiora@eastec-inc.com said:
How can I get a different footer to appear on the last
page only?
Thank you for any help you can provide.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top