Printing macro error

D

David

I am trying to create a macro to print. It prints but I get run time
error 424 object required. WHat is wrong and how can I fix it? How
can I tell it ot print 3 copies of the active sheet?

Here's my code:

Sub prtout()
ActiveSheet.PrintOut.ActivePrinter
End Sub
 
B

Bob Flanagan

Use:

ActiveWindow.SelectedSheets.PrintOut Copies:=3

or

ActiveSheet.PrintOut Copies:=3

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
D

David

That worked perfectly. Thank you very much. Could you direct me to
some resources for newbies who want to figure out VB code for
themselves? Much appreciated.
 
Top