ExcelPowerUser
Sunday, December 25, 2011
Delete Multiple worksheets
You can use this code to delete multiple sheet without loop
Sub DeleteSheet()
Application.DisplayAlerts = False
Worksheets(Array("Sheet1", "Sheet1", "Sheet1")).Delete
Application.DisplayAlerts = True
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment