PDA

View Full Version : Solved: delete sheets between two dummy sheets vba



thmh
06-12-2011, 02:57 AM
hy ,
i need to delete all sheets between two dummy sheets named "0" and "100"

Bob Phillips
06-12-2011, 09:25 AM
Dim i As Long

Application.DisplayAlerts = False

With ActiveWorkbook

For i = .Worksheets("100").Index To .Worksheets("0").Index Step -1

.Worksheets(i).Delete
Next i
End With

Application.DisplayAlerts = True