I want to print off a series of similar areas, set up on multiple pages to
reflect multiple departments - all in one print range

Print areas within an Excel sheet must be contiguous. The only way to do
what you describe is to set up different sheet tabs for each variation, set
the print area in each, and then print. If you have numbered pages, they
will print with sequential numbers if you select all the needed tabs and
print them together.

"JBC" wrote in message
...
I want to print off a series of similar areas, set up on multiple pages to
reflect multiple departments - all in one print range

Print ranges are specific to a single sheet. You can select multiple sheets
and print them all at once.

Do that by activating the first sheet to print, then hold down the Ctrl key
while left clicking on the tabs for the other sheets to print. You can also
record those steps as a macro, if that makes things easier

"JBC" wrote:

I want to print off a series of similar areas, set up on multiple pages to
reflect multiple departments - all in one print range

You can add a new sheet.

Then copy each of the ranges to that sheet, but instead of just pasting the
values, you can paste the picture of the range.

Edit|copy your first range
off to the new sheet
shift-edit|paste picture Link

And repeat for each range (butt the pictures of the ranges nicely)

Then print that worksheet.

By pasting the picture line, the pictures will change when you change the range.



JBC wrote:

I want to print off a series of similar areas, set up on multiple pages to
reflect multiple departments - all in one print range

--

Dave Peterson