Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I get this macro to print more the on sheet For example sheets
1 to 5. Sub doprint() ' ' doprint Macro ' Macro recorded 9/25/2003 by AvilaJ Dim i As Integer Dim oCell As Range Jummber1 = InputBox("Start in Job Number?", " First Job to Print", 0) Jummber2 = InputBox("Finish in Job Number?", " Last Job to Print", 0) Range("I40").Select ActiveCell.FormulaR1C1 = Jummber1 Range("I41").Select ActiveCell.FormulaR1C1 = Jummber2 For Counter = Jummber1 To Jummber1 Range("L5").Select ActiveCell.FormulaR1C1 = Counter ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate _ :=True Next Counter End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing multiple sheets... | Excel Discussion (Misc queries) | |||
printing multiple sheets | Excel Discussion (Misc queries) | |||
Printing Multiple Sheets | Excel Discussion (Misc queries) | |||
Need Help with printing multiple sheets Please | Excel Programming | |||
Printing multiple sheets. | Excel Programming |