Sub test() Dim i% Application.DisplayAlerts = False For i = Worksheets.Count To 5 Step -1 Sheets(i).Delete Next Application.DisplayAlerts = True End Sub
Sub test() Dim i% Application.DisplayAlerts = False For i = Worksheets.Count To 5 Step -1 Sheets(i).Delete Next Application.DisplayAlerts = True End Sub