Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Printing (Selecting)
Hi there,
I currently print an array of worksheets from within my code, what I would like do is check a condition on each page before it is added to the array? Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", "Sheet5", "Sheet6", "Sheet7", Sheet8", "Sheet9")).Select Sheets("Sheet1").Activate ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True At certain time I would like to exclude various sheets? Is this possible? or do I have to write code for each possible array condition? Thanks Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formulas/selecting data | Excel Worksheet Functions | |||
Vlookup - Array not selecting in other workbook | Excel Discussion (Misc queries) | |||
printing out via vb and selecting the printer | Excel Programming | |||
selecting multiple sheets by use of an array? | Excel Programming | |||
Help: selecting part of an array | Excel Programming |