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