VBA Express Forum
>
VBA Code & Other Help
>
Excel Help
> Solved: delete sheets between two dummy sheets vba
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.