Creating an array of sheets to print

Hi,

Can someone help me with this:

In VB, I want to select multiple sheets (but not all, and not allways the
same) based on certain criterias. Once this will be done, I will be able
using "ActiveWindow.SelectedSheets.PrintPreview" to print (or preview) those
selected sheets.

Thanks for your help

Luc Dansereau

If the criteria is manually applied, consider adding a form to your
workbook. For each sheet, add a checkbox as a print control.

If programmatically, record the worksheet name (or number) in an array
(or a string) if the criteria is met. Then Select them using something
like the following:

Sheets(Array("Sheet1", "Sheet3")).Select

Finally. process the array for printing.