Dynamic Print area based on range typed into a cell

[mbarbera83]

Is there a way that i can set the print area based on the INDIRECT function of a range typed into a cell.

i have a worksheet with 52 sheets.
i would like to run a Macro that runs through all the sheets and sets the Print area based on a cell in that sheet, then print that report
Then run another macro that sets print area to a different area on that same sheet and then print that.

1 report is all the pages, while other report is pages 1 and the last page. perhaps easier way to set to print all, but then a macro to print page 1 and last page of each sheet?

Any help would be appreciated.

 

[mbarbera83]

This works brilliantly!!

thanks so much!!

 

[FormR]

Glad we got there!