ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Does anyone know how to place a footer on just last page? (https://www.excelbanter.com/excel-discussion-misc-queries/136538-does-anyone-know-how-place-footer-just-last-page.html)

Burton

Does anyone know how to place a footer on just last page?
 
I have a set of excell documents that I send out quite often each month. Each
document has multiple pages. I would like to place a standard footer on just
the last page of each document. I have not been able to do this without
creating multiple copies of each document and printing only a portion.

Dave Peterson

Does anyone know how to place a footer on just last page?
 
You could use a macro.

Ron de Bruin has some code to get you started:
http://www.rondebruin.nl/print.htm#Header

Burton wrote:

I have a set of excell documents that I send out quite often each month. Each
document has multiple pages. I would like to place a standard footer on just
the last page of each document. I have not been able to do this without
creating multiple copies of each document and printing only a portion.


--

Dave Peterson


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com