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