#1   Report Post  
ChrisA
 
Posts: n/a
Default 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




  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How would I remove a pagebreak and page number on a workbook perm. Frustrated New Users to Excel 3 January 15th 05 06:25 PM
How do I print a new number on each page AJ Perkins, Wales, UK Excel Worksheet Functions 1 December 8th 04 03:05 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Change number of columns mid page? Bluemax Excel Worksheet Functions 4 November 24th 04 02:11 AM
insert a page number into a cell? Carrmuha Excel Worksheet Functions 2 November 13th 04 07:09 AM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"