Dear Coderre,

Thank you very much for the code. It helped a lot. I
have one more question to ask? How can i develop on the code, to see if
a singe value in B1 And a single value in C2 falls within the range
A1:A1000, following the same case in the previous posting where 200
6-digit numbers exist in a cell.

Thanks,
Thomas.


--
Tomac
------------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...o&userid=31555
View this thread: http://www.excelforum.com/showthread...hreadid=512494