If Not IsError(Application.Match("DOODLE",Range("J12:J88" ),0)) Then
'value found
Else
'value is not found
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"geebee" wrote in message
...
hi,

I am trying write code to determine if a specific value, lets say "DOODLE"
exists within a specified range in an excel sheet. The range specified
could
be J12:J88 for example.

Thanks in advance,
geebee