And if you know how many printed sheets there are, couldn't you just type that
in the header/footer.

Instead of using:

&[Page] of &[Pages]
use
&[Page] of 36

(or 38??)

Frank Clayton wrote:

I am printing a workbook with 6 worksheet of 6 pages each. I need to print a
worksheet but have the pages numbers done by workbook.
ie instead of 1 of 3, in need to have 6 of 38

--

Dave Peterson