I am running a search in my VBA code using:
Columns("C:C").SelectSelection.Find(What:=account, after:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
If the account is not found it returns a run-time error '91. What would be the best way to handle it. Can I do an 'If then'? I need to know what the returned value is when it is not found. Or is an error handler better. I tried using
On error go to _____: but this did not seem to work.
Thanks