Thread
:
How to display current page number in any cell of that page.
View Single Post
#
9
Posted to microsoft.public.excel.misc
Glen
external usenet poster
Posts: 68
How to display current page number in any cell of that page.
Hector could you send me this macro also, my ad is
Thanks,
Glen
"Héctor Miguel" wrote:
hi, Laljeet !
I will like 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.
IMHO, 'this'... is not that simple :-(
AFIAK, each 'cell at almost the top of the page' changes according to page setup print/printer settings
- it needs to 'scan' for row/column pagebreask, print area, print title rows/columns, print order, quality, zoom, etc.
- also, is if you 'write' on cells 'page # of ##' by code, scan for previous 'wrong-page-numbered' cells
if you only need 5 page-numbered cells, I guess an easy way could it be:
- do a printpreview
- locate those 'cell at almost the top of the page', and number them [you know the print order]
if you really need a code for that, I have one in a ~100 long-lines macro
let me know where to send it to you.
hth,
hector.
Reply With Quote
Glen
View Public Profile
Find all posts by Glen