Back to Browse

Delete Multiple Sheets Quickly Using Excel VBA

4.6K views
Nov 23, 2022
5:05

If you have a Excel file with lots of sheets, here is a quick script to delete multiple sheets at a time using Excel VBA. Sub deleteSheets() Dim ws As Worksheet Application.DisplayAlerts = False For Each ws In Worksheets If (InStr(ws.Name, "2022") = 0) Then ws.Delete End If Next ws Application.DisplayAlerts = True End Sub

Download

1 formats

Video Formats

360pmp46.0 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Delete Multiple Sheets Quickly Using Excel VBA | NatokHD