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