Find Function Excel 2007
Posted on 2014-10-15
How can I construct a VBA statement depending on the results of the Find statement below?
Cells.Find(What:="Canceled", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
If the above Find statement does not find what I am looking for and the error message "Microsoft Office Excel cannot find the data you're looking for" displays, I want the search to terminate and go onto a named macro. If it does find the value then, I want it to continue to another named macro.