I was just looking for some help with my macro, 

 
Range("V16").Select
    Range(Selection, Selection.End(xlDown)).Select
    Do Until ActiveRange.Value = ""
        If ActiveRange.Value <> "1" Then
            ActiveRange.EntireRow.Delete
        Else
            ActiveRange.Offset(1, 0).Select
        End If
    Loop
End Sub
I have a parameter set up basically if the data doesnt meet specifications then i want it to delete the entire row. the values found start at V16 and proceed down to V324. but V324 could change at anytime.

also, for some reason my if function wont work. I ve tried re writing it, manipulating the sings etc. but to no avail. Here it is:

=If(0.7<=A17<=3,1,"")

thanks for the help!