Or a different approach.
Sub Or_So_Maybe() Dim dataArr, i As Long, rng As Range dataArr = Sheets("Sheet1").Range("A1:D" & Cells(Rows.Count, 4).End(xlUp).Row).Value For i = 8 To UBound(dataArr) If dataArr(i, 4) = 0 Then If Not rng Is Nothing Then Set rng = Union(rng, Cells(i, 1).EntireRow) Else Set rng = Cells(i, 1).EntireRow End If End If Next i If Not rng Is Nothing Then rng.Delete Shift:=xlUp Set rng = Nothing End Sub




Reply With Quote