Say I have a macro that contains...
Cells.Find(What:="HELLO", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Select
Now if, "HELLO" is not on the page, you get an error. Can someone tell me the on error next thing I need to include. I know it's simple, but I forget the exact code.
Thanks a bunch!
mk
Cells.Find(What:="HELLO", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Select
Now if, "HELLO" is not on the page, you get an error. Can someone tell me the on error next thing I need to include. I know it's simple, but I forget the exact code.
Thanks a bunch!
mk