Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I keep heading so it prints on multiple pages | Excel Discussion (Misc queries) | |||
when printing multiple sheets, first prints single side rest doub. | Setting up and Configuration of Excel | |||
½ symbol prints a 2 and Winding square box prints a F | Excel Discussion (Misc queries) | |||
multiple prints in Excel | Excel Discussion (Misc queries) | |||
macro only prints out first and last line of document | Excel Programming |