Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie he I have a question about a print macro I am trying to write...
Essentially what I am trying to do is create a print macro that will print selected sheets from a massive group of worksheets. I have created the following macro which works however, this requires me to name print areas for each specific category, which has a number of sheets associated to it. I am sure there is an easier way to go about this rather than Naming print areas for thousands of sheets. Sub Macro37() Application.Goto Reference:="Consolidated_2006_Actual" ActiveSheet.PageSetup.PrintArea = Selection.Address ActiveWindow.SelectedSheets.PrintOut Copies:=1 Application.Goto Reference:="Consolidated_2006_Budget" ActiveSheet.PageSetup.PrintArea = Selection.Address ActiveWindow.SelectedSheets.PrintOut Copies:=1 Application.Goto Reference:="Consolidated_2005_Actual" ActiveSheet.PageSetup.PrintArea = Selection.Address ActiveWindow.SelectedSheets.PrintOut Copies:=1 Application.Goto Reference:="Consolidated_TTM" ActiveSheet.PageSetup.PrintArea = Selection.Address ActiveWindow.SelectedSheets.PrintOut Copies:=1 Application.Goto Reference:="Consolidated_Rolling_Actuals" ActiveSheet.PageSetup.PrintArea = Selection.Address ActiveWindow.SelectedSheets.PrintOut Copies:=1 Application.Goto Reference:="Consolidated_NOI_Valuations" ActiveSheet.PageSetup.PrintArea = Selection.Address ActiveWindow.SelectedSheets.PrintOut Copies:=1 Application.Goto Reference:="Print_Directory" End Sub Any help would be appreciated!! Thanks!! KYABA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Macro Question | Excel Discussion (Misc queries) | |||
Print Question Newbie Please help | New Users to Excel | |||
Newbie seeks suggestion on recording new macro to print sheets | New Users to Excel | |||
How to write a macro to print a dir on my c drive | Excel Programming | |||
Total newbie question involving pasting someone else's Macro | Excel Programming |