I have a set of sheets in a workbook where there are two
sections of data per sheet.
The workbook is saved with one set of data pre set in the
print set up.

However, I need to set a macro where the other set of data
per sheet will be printed, and then the print set up
returned to point to the first set of data.

Can I do something with named ranges etc?

Thanking you in advance.