Hi magicians,
I'm trying to delete rows if the value in column E is between -0.01 and 0.01...unfortunately I can't just delete if it is simply 0 as there are rounding's to many millions after the decimal point so have to do between -0.01 and 0.01 to remove anything for 0.00.
I thought about just using the "and" between the IF statement as per below, but VBA doesn't like it.....any ideas? Thanks!
I'm trying to delete rows if the value in column E is between -0.01 and 0.01...unfortunately I can't just delete if it is simply 0 as there are rounding's to many millions after the decimal point so have to do between -0.01 and 0.01 to remove anything for 0.00.
I thought about just using the "and" between the IF statement as per below, but VBA doesn't like it.....any ideas? Thanks!
VBA Code:
lrow2 = Cells(Rows.Count, "B").End(xlUp).Row
For i = lrow2 To 1 Step -1
If Cells(i, "E") >-0.01 and <0.01 Then
Rows(i).Delete
End If
Next i