| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Numbers
A friend of mine has an Excel file with fifty worksheets. He can select all
the sheets for printing, but each new sheet gets a new page number, that is, they all get page number one. And idealy, he would like it to say 1 of 50 and 2 of 50, etc. in the footer. Is there any way to advance the page number even if the output comes from different sheets and determine the total page number? I suspect setting up a variable in VB and advancing it by one for each new page, but my experience with VB is limited to Access so if someone could help me out I would be very grateful. -- Michael Conroy Stamford, CT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page numbers on copies of a single page worksheet | Excel Discussion (Misc queries) | |||
| Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) | |||
| Page numbers - not starting from the first page | Excel Discussion (Misc queries) | |||
| Page Break Page Numbers | Excel Discussion (Misc queries) | |||
| consecutive page numbers of the same page | Excel Discussion (Misc queries) | |||
Threaded Mode
