number worksheets in workbook

[Guest]

I have a workbook that has one worksheet that will print on mulitple pages.
In the same workbook I have single worksheets. I need to know how I can print
two different ways.

1. How can i print were the numbers for the single sheet will have page
numbers sequentially after the sheet that spans mulitple pages.
and...
2. I have to print from a document all the single sheets using sequential
page numbers. The post that said to use &[Page] Of &[Pages] did not work
for me. I keep getting page 1 of 14 on every page
What am I doing wrong?

 

[Gord Dibben]

Your set up is correct for the single sheet with multiple pages.

Just select that one sheet to print.

To set up for printing multiple sheets with sequential page numbers.......

Select the sheets to print by CTRL + Click on the sheet tabs.

Set up your page? of pages on one sheet then print the "ActiveSheet(s)

Two separate print jobs for 1. and 2.


Gord Dibben MS Excel MVP