This documentation is archived and is not being maintained.
How to: Refer to More Than One Sheet
Use the Array function to identify a group of sheets. The following example selects three sheets in the active workbook.
Sub Several() Worksheets(Array("Sheet1", "Sheet2", "Sheet4")).Select End Sub