Home » Blogs » Vishesh's blog

Using Array to refer to multiple sheets

Vishesh's picture
Submitted by Vishesh on 10 July, 2011 - 18:41
The following example code deletes multiple sheets in one go. 
Sub DeleteMultipleSheets()
    Application.DisplayAlerts = False
    With ThisWorkbook.Worksheets(Array("Sheet2", "Sheet3"))
        .Delete
    End With
    Application.DisplayAlerts = True
End Sub
»