Find matching text

[JohnSearcy]

I have part of some sample code:

With Worksheets("Sheet1").Range("A10:A20")
Set F = .Find(X)

This works, but it doesn't always find the exact match of X. Ex. if X = 1000, then it will find a cell with 31000.

I've done the trial and error, but nothing works. Somthing simple?

Thanks,
John

 

[mirabeau]

With Worksheets("Sheet1").Range("A10:A20")
Set F = .Find(X, lookat:=xlwhole)

 

[JohnSearcy]

Perfect. Thanks much, man!!