Try something like

Dim FoundCell As Range
Set FoundCell = Range(your_range).Find(what:="abc")
If Not FoundCell Is Nothing Then
Debug.Print "Found: " & FoundCell.Address
Else
Debug.Print "Not Found."
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Trent Argante" wrote in
message
...
How do i get the Find method to programmically return whether
it found the
specified value or not?
--
Trent Argante
[DC.J(455)]