Excel: Dynamic Print area based on range typed into a cell

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.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of June 02, 2015.

For more resources for Microsoft Excel