Hi all

How do I detect when the following code returns nothing, meaning when no
match is found? I need to when no match is found and then take different
action. Please share with me the code syntax to do this? Thanks.

Cells.Find(What:="xyx", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=False).Activate



Ben


--