Hi.

The following code line searches for a value. When it
finds the value, further code will peform some other
actions.

My problem is when the string is not found. Is there a
way to use a conditional statement if the value is not
found?

Thanks,
Mike.

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