If you use File, Print Area, Set Print Area on each worksheet, after
selecting the print range, each sheet will be set to print just the right
range. Then from File, Print select Entire Workbook as the "print what".

--
Jim Rech
Excel MVP
"Angela" wrote in message
...
|I would like to create a macro that will print multiple
| selections from multiple worksheets to the same file all
| at once. Currently I can only program the macro to print
| each selection separately.
|
| I am using a monster of a multiple worksheet excel file
| and am trying to print various selections to one pdf
| file. Will end up being approx 12 pages.