Share via

How to: Refer to More Than One Sheet

  • Article
  • 06/14/2014
Excel Developer Reference

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