Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing certain pages
A rather simple problem but I can't find what I want in help.
I wish to loop through each sheet in the workbook and print those called WIP* I was think of somethig like: Private Sub PrintWIPButton_Click() Dim SheetNum As Integer For SheetNum = 1 To Worksheets.Count If Sheets(SheetNum).Name Like "WIP*" Then !!!! Add to a collection (or array?) of sheets !!!! End If Next SheetNum ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Worksheets(1).Select End Sub --------------------------------- I'm just having problems in defining a collection of sheets. Can anyone fill in the missing line of code?? TIA! Nick Shinkins |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Printing Odd or Even Pages | Excel Discussion (Misc queries) | |||
Printing to various pages | Excel Discussion (Misc queries) |