I want to find the row no assigned to date from a range of column(area_date) as following code:

r = Range("area_date").Find(Range("test_from")).Row

the r should be found from correct date 1-Apr-2012(test_from), but sometime r was found from wrong date 4-Jan-2012.
why and how to solve it? thks.