Tom -

Thank you. Toppers message never made it to my news server, but I see
the way to go.

Thanks again.
....Hash

In article ,
"Tom Ogilvy" wrote:

Using Toppers approach is fine if you are guaranteed that the target value
will be found. If not, it is better to set a reference to the result of the
find command and then test if Find was successful

Dim rng as Range
set rng = Columns("C").Find("123")
if not rng is nothing then
rw = rng.row
Else
msgbox "123 not found"
exit sub
End if