print copy

[kalpeshpatel]

i want to print 2 copy of worksheet 1 page 1


Only for macro


pls give me a macro

 

[SirJB7]

Hi, kalpeshpatel!

Try this:

Sub AnotherWeirdMacro()

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=2, Collate:=True, IgnorePrintAreas:=False

End Sub

Regards!