Hi All !

I'm only 2 days old using macros .... lol

I used a macro to print a worksheet as follows :


Sub PrintSheet()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("C11") <> "" Then
ws.PrintOut 1, 1, 1, ActivePrinter:=HP_LaserJet_P1005
End If
Next ws
End Sub


Is there a way to make it print the same sheet on another printer as well.

Thanking you in advance for any suggestions