Find Tool in worksheet retrieving value not the same as entered data

[SBF12345]

I was attempting a find in vba...it was giving a problem so I tried to find the same value with the find tool in the worksheet.

With all cells selected I opened find and entered the date "02/10/10", hit "find next" and got the result "12/10/10". What the heck? How, Why?

anybody had this occur before?

 

[footoo]

Try this :

Sub FindDate()
Dim dte As Date, rng As Range, i As Variant, cel As Range
dte = "02/10/10"
Set rng = [A1:A10]
i = Application.Match(CLng(dte), rng, 0)
If Not IsError(i) Then Set cel = rng(i)
End Sub

 

[footoo]

With all cells selected I opened find and entered the date "02/10/10", hit "find next" and got the result "12/10/10". What the heck? How, Why?

If you enter in Find 2/10/10 and 02/10/10 does not exist in the selection, and 'Match entire cell contents' is not checked, Find will go to the first partial match.

 

[SBF12345]

correct, in VBA it requires xlWhole, Thanks footoo