Want to set same print range to many sheets

[PeteABC123]

Have 2 ranges on each sheet that I want set per the graphic below. Excel will not allow grouping and setting page print properties(ranges) while grouped. Also need no breaks per range, see page tab.

Is there a way to do this? I have 84 pages to set this print range on.

TIA.

Pete

Print Ranges Multiple sheets.JPG

[JLGWhiz]

you would need a macro with a loop something like this.

Please Login or Register  to view this content.

I used 1 - 84 for sheet index numbers, but your sheets might start on a different index and may not be sequential, so the code needs to be validated before trying it. In any event, what it essentially does is send 84 print commands to the printer buffer and if no other print job takes priority, it should then print the sheets' print ranges sequentially, but page numbers will not continue from one sheet to the next. The page numbers will begin anew with each sheet.

[PeteABC123]

Thank you JLGWhiz.

Pete