I want to use a macro to delete the range A:F in every row where the value in column E is equal to "del".
I came up with this, but it does not work:
So.. please help
I came up with this, but it does not work:
Code:
For i = 1 To 35000
If Cells(i, 5) = "del" Then
With Range(Cells(i, 1), Cells(i, 6)).Select
Selection.Delete Shift:=xlUp
End With
End If
Next i
So.. please help