ExcelBanter - How to display current page # in any cel , not header & footer

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

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

- - How to display current page # in any cel , not header & footer (https://www.excelbanter.com/excel-discussion-misc-queries/129669-how-display-current-page-any-cel-not-header-footer.html)

Tpeila

How to display current page # in any cel , not header & footer

I am trying to display in a cell at almost the top of the page, the page
number.
E.g. Page 1 of 5 next Page 2 of 5 ...in a five page document. How do i do
this? I have Excel 2003. I saw someone had a macro for it. I need one ASAP.
Please e-mail to

All times are GMT +1. The time now is 09:15 AM.