Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Loop a Function
I have the current function:
Sub Printing() Sheets(ActiveSheet.Index + 1).Activate ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub I then want the formula to restart itself on teh current sheet and then move the next sheet and print the data and so and so on (I have 300 sheets that need to be printed individually to maintain the correct page numbering). Thanks for the help. Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Loop a Function
Sub Printing()
for i = 1 to 300 Sheets(i).Activate ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next i End Sub -- Regards, Tom Ogilvy " wrote: I have the current function: Sub Printing() Sheets(ActiveSheet.Index + 1).Activate ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub I then want the formula to restart itself on teh current sheet and then move the next sheet and print the data and so and so on (I have 300 sheets that need to be printed individually to maintain the correct page numbering). Thanks for the help. Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Loop a Function
Thanks Tom.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does loop function cause this problem? | Excel Worksheet Functions | |||
If-Else Simple Loop function | Excel Programming | |||
Loop Function unable to loop | Excel Programming | |||
Calling a function from a subroutine loop | Excel Programming | |||
Need function for checkbox in loop | Excel Programming |