hi,

how can i select worksheets in a workbook based on a certain criteria.

For example, I have worksheets that start with "18" together with other worksheets.
1811, 1812, 1813....1899, Data, PivotTable, etc....

how can I select only the worksheets starting with "18" using a macro?

these worksheets are generated by showing all pages using a pivottable. hence the using the Sheets(Array(x,y,z...)).Select will not work.
as its difficult to determine the exact no. of sheets starting with "18" everytime the macro is run.

any help is greatly appreciated!

josnah