Re: $$Excel-Macros$$ Printing: page count exceeds the number of pages in the tab

2012-02-02 Thread David Grugeon
Simple stuff Check that the footer says "page [page] of [pages]", not "page [page] of 7" Go to the page setup dialog by using the tiny arrow in the corner of page setup section on the page layout tab. On the Page tab of that check that "start page numbering at" is set to Auto or 1. check that

$$Excel-Macros$$ Printing: page count exceeds the number of pages in the tab

2012-02-02 Thread DaveO
Troubleshooting a colleague's file: on a print-out he wants to show "Page X of Y" in the footer. The tab contains 5 pages of formatted material. Print preview shows "Page 7 of 5" and it appears that way on paper as well. There are no hidden rows or columns; no conflicting PrintArea named ranges; th