OK, I have a report that is 41 pages long. The first 15 pages are on individual tabs, each with a hard coded custom footer that represents pages 1 - 15. However, the last 26 pages are in one tab, which happens to be the last tab.
Here's the problem. Clients can print the whole report or individual pages. If they print just the last tab, I'm OK in using &[Page]+15 in the footer and the pages print fine as 16 - 41. However, if they opt to print the whole report, the page numbers come out as 1 - 15 and 30 - 55 as Excel tries to help out when the entire workbook is printed and automatically assigns sequential numbers to the &[Page] piece of the footer.
FYI, i'm calling a print routine via VB and i suppose a way around this would be to call two separate routines, but i'd rather not, and i'm curious if there is a way around this.
Thanks for reading all of this and any assistance would be much appreciated.
thanks, mike
Here's the problem. Clients can print the whole report or individual pages. If they print just the last tab, I'm OK in using &[Page]+15 in the footer and the pages print fine as 16 - 41. However, if they opt to print the whole report, the page numbers come out as 1 - 15 and 30 - 55 as Excel tries to help out when the entire workbook is printed and automatically assigns sequential numbers to the &[Page] piece of the footer.
FYI, i'm calling a print routine via VB and i suppose a way around this would be to call two separate routines, but i'd rather not, and i'm curious if there is a way around this.
Thanks for reading all of this and any assistance would be much appreciated.
thanks, mike