Situation: I'm printing multiple worksheets, each with 1 or more pages, in
the same workbook. Each sheet has a header and/or footer which contains 'Page
x of xx pages". The page number correctly resets to 1 with each new sheet.
The number of pages, however, does not. Every sheet prints as Page 1(2,3...)
of 106 (the total number of pages being printed, NOT the total # of pages in
each particular worksheet.) Is there a way to reset the "number of pages" at
the end of each sheet?

Thanx.