Find row no for date

[alee001]

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.

[dilipandey]

Suggest you to check the value of "test_from" while running macro in break mode and then you can figure out the root cause. thanks.



Regards,
DILIPandey
<click on below * if this helps>