Macro to delete sheets
Try this
Sub deleteSheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
With Application
.DisplayAlerts = False
With ws
If .Name = "PLANID" Or .Name = "FEETOTAL" Then
.Delete
End If
End With
.DisplayAlerts = True
End With
Next
End Sub
"Jodie" wrote:
How can I delete sheets with the names PLANID or FEETOTAL through VBA?
--
Thank you, Jodie
|