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