extracting page number from page setup footer

[Conor]

Does anyone know how to pull the page number from the page setup footer? For example, if the page number is in the right hand section of the footer, how can it be inserted into a cell on the worksheet?

Let's say put each page number in column C starting in C3.

Thanks in advance for any help.

Conor

[Conor]

Has this stumped even the moderators? Any takers?

[royUK]

The actual page number is not in the footer. Try this to see what I mean

Please Login or Register  to view this content.

You need to work with PageBreaks. You will need to adjust the difference between rows, I have used 50

Please Login or Register  to view this content.