Find Exact Number with Excel VBA

[jcoat]

So I'm doing a simple search replace

anode = 123
With Range(Columns(5), Columns(5))
     Set C = .Find(What:=anode, SearchFormat:=False)
     C.Value = newvalue
End With

How do I set my find so that I only return cells valued "123" not "1123" or "1239"?

Thanks

 

[jcoat]

Oops, I think I found the problem... I need LookAt:=xlWhole