Bestimmte Zeilen löschen
02.05.2012 16:07:31
Erich
Hi Micha,
probier mal:
Option Explicit
Sub Makro1()
Dim lngZ As Long, zz As Long, rngDel As Range
Cells(2, 6).FormulaArray = _
"=D2+ROW(D2)%%=MIN(IF($A$2:$A$14&$B$2:$B$14=$A2&$B2,D$2:D$14+ROW(D$2:D$14)%%))"
Cells(2, 7).FormulaArray = _
"=E2+ROW(E2)%%=MAX(IF($A$2:$A$14&$B$2:$B$14=$A2&$B2,E$2:E$14+ROW(E$2:E$14)%%))"
lngZ = Cells(Rows.Count, 4).End(xlUp).Row
Range("F2:G2").Copy Range("F3:G" & lngZ)
For zz = 2 To lngZ
If Cells(zz, 6) Or Cells(zz, 7) Then
Else
If rngDel Is Nothing Then
Set rngDel = Cells(zz, 1)
Else
Set rngDel = Union(rngDel, Cells(zz, 1))
End If
End If
Next zz
If Not rngDel Is Nothing Then rngDel.EntireRow.Delete
End Sub
Rückmeldung wäre nett! - Grüße aus Kamp-Lintfort von Erich