LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default How can I get the number of a printed page for use in a cell?

How can I get the number for a printed page for use in a
cell?

I want to make a table of contents that has the page
number that the first page of each sheet when it is
printed.

The number of pages for each sheet varies depending
on the page length used, so I don't see how to get
the page numbers unless do a Print Preview, look at the
page numbers in the print footers, and then edit the
table of contents page.

Is there a function to get the page that a cell prints
on in the print preview? This would allow me to do a Print
Preview and have the page number be inserted on each reference
page, which I then could use in the contents page.

Thank you.
 
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 to display current page number in any cell of that page. Laljeet Excel Discussion (Misc queries) 8 February 2nd 08 01:31 AM
Configuring the number of rows printed per page BK-DWS-NJ Excel Discussion (Misc queries) 3 July 20th 07 05:04 PM
Increment a number in a cell for each page printed Steve Vincent Excel Discussion (Misc queries) 6 June 19th 06 11:12 PM
New form number for each page printed jimqual7 Excel Discussion (Misc queries) 6 March 20th 06 04:24 PM
sheet tabs as page number and in a cell page of pages? [email protected] Excel Discussion (Misc queries) 0 November 22nd 05 02:43 PM


All times are GMT +1. The time now is 04:07 PM.

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

About Us

"It's about Microsoft Excel"