View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
will will is offline
external usenet poster
 
Posts: 11
Default Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook

I thought that this would do it but it is giving me an error of:
1004 Methough PrintOut of object Sheets failed

Sub PrintMacro()
vCopies = InputBox("How Many Copies?")
i = 1
For i = 1 To vCopies
Sheets.PrintOut
Next i
End Sub

Any help is appreciated
Thanks