ExcelBanter - Enquiry

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Enquiry (https://www.excelbanter.com/excel-discussion-misc-queries/210660-enquiry.html)

Leng

Enquiry

How can I put header at only the top page and footer at only the last page?

Dave Peterson

Enquiry

You can use a macro to print the sheets. And the macro would adjust the
header/footer for each sheet.

Ron de Bruin has some sample code:
http://www.rondebruin.nl/print.htm#not

Leng wrote:

How can I put header at only the top page and footer at only the last page?

--

Dave Peterson

All times are GMT +1. The time now is 08:15 PM.