Sub WksDelete() Application.DisplayAlerts = False Dim WksIndex As Long, WksDel As Long ReDim WksNamen(1 To Worksheets.Count) As String For WksIndex = 1 To Worksheets.Count If Worksheets(WksIndex).Range("B1") = "meinText" Then WksNamen(WksIndex) = Worksheets(WksIndex).Name Next WksIndex For WksDel = 1 To UBound(WksNamen) If WksNamen(WksDel) <> "" Then Worksheets(WksDel).Delete Next WksDel Application.DisplayAlerts = True End Sub
58.4k Fragen
249k Antworten
7k Nutzer