HELP - I need some help with page numbering tabs

[jminder59]

Hi,
I need to be able to print page numbers (e.g. page n of n pages) on pages
within tabs. If I print an individual tab, that works fine. There are a ton
of tabs. Printing them individually would take all day. If I print the
entire workbook, it numbers the pages from 1 to whatever the total number of
pages in the entire workbook. The correct tab names are printed in their
correct relative position, but the numbering is page 1 of the entire
workbook through page last of the entire workbook.

 

[James Ravenswood]

Hi,
I need to be able to print page numbers (e.g. page n of n pages) on pages
within tabs. If I print an individual tab, that works fine. There are a ton
of tabs. Printing them individually would take all day.  If I print the
entire workbook, it numbers the pages from 1 to whatever the total numberof
pages in the entire workbook. The correct tab names are printed in their
correct relative position, but the numbering is page 1 of the entire
workbook through page last of the entire workbook.

You could use a macro to loop over all the tabs in a workbook and
print them individually. The page numbers would reset to 1 on each
tab.