| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer Page Number Question
My Excel 97 application has several reports. For 1-page reports I write the
footer 1 of 1. For 2-page reports I write &[Page] of &[Pages]. The problem is when all reports (single and multiple page) are printed out at once the 2-page reports refer to the total number of pages being printed. When a 2-page report is printed out with 6 1-page reports, instead of being 1 of 2, 2 of 2, it becomes 1 of 8, 2 of 8. Is there a VBA solution? Thank you in advance. Jim Kobzeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Footer - Page Number problem | Excel Discussion (Misc queries) | |||
| Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
| Unique Footer for each page in worksheet with a page number | Excel Worksheet Functions | |||
| Continuation of Page number in footer | Excel Worksheet Functions | |||
| Page Number - not in header/footer | Excel Discussion (Misc queries) | |||
Threaded Mode
