L
Leporello
I have a simple three sheet workbook which contains the macro below to print
one part of one of the sheets. I wish to amend it to print several copies,
depending on the user input in cell G16 of sheet "Input". Can I alter the
Selection.Printout line of the macro or should I use a loop structure? In
either case some help on the syntax would be appreciated.
Sub Button6_Click()
'
' Button6_Click Macro
' Macro recorded 03/08/2009 by
'
Sheets("Mark sheet").Select
Range("A1:H56").Select
Range("H56").Activate
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Input").Select
Range("A1").Select
End Sub
one part of one of the sheets. I wish to amend it to print several copies,
depending on the user input in cell G16 of sheet "Input". Can I alter the
Selection.Printout line of the macro or should I use a loop structure? In
either case some help on the syntax would be appreciated.
Sub Button6_Click()
'
' Button6_Click Macro
' Macro recorded 03/08/2009 by
'
Sheets("Mark sheet").Select
Range("A1:H56").Select
Range("H56").Activate
Selection.PrintOut Copies:=1, Collate:=True
Sheets("Input").Select
Range("A1").Select
End Sub