IsError... error?

I'm trying to check if a value exists inside of a range using the Find function, as follows:

Please Login or Register  to view this content.

The problem is, the IsError function returns a "false" in all situations, even when the value doesn't exist. But if I try to run the Find function on its own in that case, it gives me the Error 91 "Object not set." Isn't "IsError" supposed to detect when something triggers an error?

What should I be doing instead to avoid the error messages and read that value as a "True" for the purposes of my If statement above?

You need to defind the variable you are trying to find as an object(Range) and use a set to the range. You then include line another to test if the object(Range) exist. If not objetname is nothing then.
Is error is meant to test if there is an error on the cell you are trying to evaluate.
dim rng as range.
Like

Please Login or Register  to view this content.

With the "Is Nothing" added, it actually worked exactly as I wrote it - thanks for the help!