Page Number Fuction
 

Is there a function that will show the current page number in a cell? I am
looking for a fuction similar to the ROW() or the COLUMN() fuction but with
the page number. Depending on my settings in "page setup", this number
should change according to the current page number that it is displayed on.

I know there must be a way to do this because you can do it in the footer.

Thanks

Chris

Chris

http://www.dicks-blog.com/archives/2...ges-in-a-cell/


Gord Dibben Excel MVP

On Thu, 17 Feb 2005 08:15:03 -0800, ChrisA
wrote:

Is there a function that will show the current page number in a cell? I am
looking for a fuction similar to the ROW() or the COLUMN() fuction but with
the page number. Depending on my settings in "page setup", this number
should change according to the current page number that it is displayed on.

I know there must be a way to do this because you can do it in the footer.

Thanks

Chris