mbarbera83
New Member
- Joined
- Feb 17, 2015
- Messages
- 27
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.
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.