I have the following code:
If the string in strWT is not found, it errors out.Code:Range("B7:AA7").Select Selection.Find(What:=strWT, After:=ActiveCell, LookIn:=xlValues, LookAt _ :=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate
How can I test it to find out if it found the strWT or ont, so that i can pop up a message that says Can not find strWT?
Looked for an answer on the posts, but couldn't find anything specific to the above.




Reply With Quote