How to display current page number in any cell of that page.

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.

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.

Hector:

I need this desperately! Please send to:

[email protected]

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

Thank you!

Ron Petersen


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

Hi Hector Miguel

Sorry for the delayed response./

Can youo pleas esend me the code to do the page numbering

Thanks.

M Laljeet

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

Sen it to [email protected]

THanks


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