using this:
xls.Cells.Find(What:=SEARCH_STRING, After:=xls.ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False).Activate
You get an error if it cand find it.. how do I trap for this? should I just use a regular error trap? or is there a better way....
Thanks




Reply With Quote