Paul Whitaker
New Member
- Joined
- Jul 10, 2002
- Messages
- 19
I have a workbook with 10 worksheets where the 5th & 6th worksheets prints onto several pages. I would like to print the entire workbook with the 5th & 6th worksheets only having footers of Page x of y, etc (the number of pages may vary month by month).
When I enter the footers the 5th sheet prints "Page 6 of x" as it is considering the Total number of pages both before and after, and not just the number of pages in the worksheet.
Is there a non-VB way around this.
Thank you
When I enter the footers the 5th sheet prints "Page 6 of x" as it is considering the Total number of pages both before and after, and not just the number of pages in the worksheet.
Is there a non-VB way around this.
Thank you