AW: Tabellenblätter nach inhalt durchsuchen und lösche
05.08.2014 20:35:42
Christian
Hallo Christian,
auch hierzu ist das Archiv voll mit Vorschlägen!
ein Ansatz:
Option Explicit
Sub spenski()
Dim x As Long, y As Long, rowl As Long, rowl1 As Long
Dim wkscont As Worksheet, wksx As Worksheet
Set wkscont = ActiveWorkbook.Worksheets("Control")
With wkscont
rowl1 = ActiveWorkbook.Worksheets("Tabelle1").Cells(Rows.Count, 1).End(xlUp).Row
For y = 1 To rowl1
Set wksx = ActiveWorkbook.Worksheets("Tabelle1")
If IsNumeric(Application.Match(wksx.Cells(y, 1), .Range(.Cells(4, 2), .Cells(8, 2)), 0)) Then
wksx.Rows(y).ClearContents
End If
Next y
For x = 2 To 11
Set wksx = ActiveWorkbook.Worksheets("Tabelle" & x)
rowl = wksx.Cells(Rows.Count, 4).End(xlUp).Row
For y = 1 To rowl
If IsNumeric(Application.Match(wksx.Cells(y, 4), .Range(.Cells(4, 2), .Cells(8, 2)), 0)) _
Then
wksx.Rows(y).ClearContents
End If
Next y
Next x
For x = 16 To 17
Set wksx = ActiveWorkbook.Worksheets("Tabelle" & x)
rowl = wksx.Cells(Rows.Count, 4).End(xlUp).Row
For y = 1 To rowl
If IsNumeric(Application.Match(wksx.Cells(y, 4), .Range(.Cells(4, 2), .Cells(8, 2)), 0)) _
Then
wksx.Rows(y).ClearContents
End If
Next y
Next x
End With
End Sub
MfG Christian