Macro Help

C

cvgairport

I am trying to craft a macro that will print assorted sheets in a single
excel file. I have written the one below but it won't run. Any help would
be appreciated.

Amy

Sub Final()
'
' Final Macro
' Macro recorded 10/26/2009 by
'
' Keyboard Shortcut: Ctrl+f
'
Sheets("Dashboard").Select
PrintOut Copies:=1, Collate:=True
Sheets("Parameters").Select
PrintOut Copies:=1, Collate:=True
End Sub
 
J

Jacob Skaria

Try the below. You can add more sheets to the array

Sub Final()
Sheets(Array("Dashboard", "Parameters")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

If this post helps click Yes
 
C

cvgairport

Worked great! Thanks!

Jacob Skaria said:
Try the below. You can add more sheets to the array

Sub Final()
Sheets(Array("Dashboard", "Parameters")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

If this post helps click Yes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Word macro that can call cells out of Excel for a find and replace 0
Macro to Select text from a point given to a specific word 2
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Excel 2007: Creating a macro that will run Solver. 0
print 2 sheets on one paper 5
Pop Up Message before printing 3

Top