Hi

I have this really simple code...

Dim i As Integer

For i = 1 To 400

    If Range("A" & i).Value = "1" Then
        
        Range("A" & i).EntireRow.Delete
        
    End If
    
Next i
Unfortunately the range it is looking at is full of formulas and therefore the code isnt working properly.

What am i doing wrong??

I know there's an easy answer for this ans i'm going to kick myself when i find out!!

Thanks