It's not the value is not there(the test value is even the first value in the
range), it's that I'm getting a runtime error and I want to fix it but once I
get the code to find a known value would also like to handle the error when
the value is not found.

Tom Ogilvy wrote:
What are you asking? How to handle the error when the value is not found?

I have two workbooks; one contains a list of mtrl Lot numbers in one column
and in the next wether it was accepted or not; the other worksheet is a form
[quoted text clipped - 34 lines]
Next x
End Sub

--
C is great... C++ is God's sin