Find 1st closet value in column

[harts]

I need to be able to find the first value in column P that is above 89 & below 91 & stop there. The VBA I am using now keeps going & doesn't stop. Because of how I am using it I would like to leave it in VBA & not a formula. Looking for any help. Thanks in advance. Here is what I currently have:

For x1 = 2 To Range("P" & Rows.Count).End(xlUp).Row
If Range("P" & Format(x1) - 1).Value < "91" _
And Range("P" & Format(x1)).Value > "89" _
And Range("P" & Format(x1)).Value > "0" Then
Range("V22") = Range("N" & Format(x1)).Value
End If
Next

 

[Dryver14]

I'm not sure what you mean by leave it in vba and not a formula.


If this is only likely to occur once then place exit sub at the bottom of the if statement above the line end if

 

[harts]

It can reoccur several times after the first time it finds it.

 

[Dryver14]

so do you want it to just select the cell and stop?

 

[harts]

Yes it needs to stop after if finds it the first time.