![]()
Sub Macro1() Dim ws As Worksheet For Each ws In Worksheets If ws.Name = "Main" Then Exit Sub Application.DisplayAlerts = False If Not InStr(1, ws.Range("A1").Value, "apple") = 0 Then ws.Delete Application.DisplayAlerts = True Next End Sub
![]()
Sub Macro1() Dim ws As Worksheet For Each ws In Worksheets If ws.Name = "Main" Then Exit Sub Application.DisplayAlerts = False If Not InStr(1, ws.Range("A1").Value, "apple") = 0 Then ws.Delete Application.DisplayAlerts = True Next End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks