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?