How to make Selection.Find is locate an entire number instead of only the begging of it?

Question

Hello guys, I have the following problem: in my macro, I select a range and try to locate a number within this selection. The problem is that if the number I am searching is 16 and there is a 160 followed by a 16 in the list, it finds the 160. How do I solve this?? Ideas?

Range("AC7:AK12").Select
Selection.Find(What:=numbe, After:=ActiveCell, LookIn:=xlValues, _
    LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False, SearchFormat:=False).Activate

Answer 1

Try LookAt:=xlWhole:

Range("AC7:AK12").Select
Selection.Find(What:=numbe, After:=ActiveCell, LookIn:=xlValues, _
    LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False, SearchFormat:=False).Activate