Have you downloaded the report manager? I have found this is great
for multiple ranges on multiple sheets and it's set up as a "report"
and one or two clicks and it prints.

http://support.microsoft.com/default...b;EN-US;214258

"jfm" wrote in message ...
Would anyone have a macro that loops through all sheets
within any one workbook and generates sequential page
numbers? Thanks in advance for your help!