Thread: Macro Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cvgairport cvgairport is offline
external usenet poster
 
Posts: 30
Default Macro Help

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