Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Refer to More Than One Sheet

Office 2007

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

Community Additions

© 2015 Microsoft