Hi guys I have these two Macros that will print two ranges from a sheet on two different sheets. :
Sub Macro1() Range("Q:AC").Select ActiveSheet.PageSetup.PrintArea = "$Q$1:$AC$100" ActiveWindow.SelectedSheets.PrintOut Copies:=1 End Sub
I need to apply this code to Sheets named "10" all the way to "360" so I just run the macros and it will print these ranges from all the sheetsSub Macro2() Range("AD:AS").Select ActiveSheet.PageSetup.PrintArea = "$AD$1:$AR$100" ActiveWindow.SelectedSheets.PrintOut Copies:=1 End Sub
Also if you have any suggestions on how to turn the 2 macros into one that would be great too!
Please help!!
Thanks
Bookmarks