Printing using a macro

[imported_unknown]

I have a file with about 5 different worksheets. I want to make macro that would print 5 copies of 1, 2 copies of another, etc. How do I do this? I tried making a macro, but it keeps on printing off of one sheet, not changing sheets like I want it to.

 

[plettieri]

Welcome Oneifreak

When you prepared your macro be sure to have the number of copies noted...ie "Printout Copies=2"

("G33:J42").Select
Range("E20").Select ActiveWindow.SelectedSheets.PrintOut Copies:=2
End Sub

you can do this on the auto record macro feature..
does this help?

pll
This message was edited by plettieri on 2002-10-06 20:57