How to: Refer to More Than One Sheet

Last modified: June 30, 2011

Applies to: Excel 2013 | Office 2013 | VBA

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
Show:
© 2015 Microsoft