I have 2 list of data, and try to use find method to match the data.
However, i noted that find method do not work if the value to find is
with decimal point.
eg if the value is 12345, the target range is marked, but if the value
is 12345.5, then find miss the cell even though it really exist.


Yes:

change

lookat:=xlWhole

to:

lookat:=xlPart

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com