I tried with that ... I could'nt get those
will you please provide the code....

Cell A1 conatins AM_CM_0001
Cell B1 conatins AM_CM_1000

GIven value is AM_CM_0050


need to compare the characters then have to check whether the give
value is in that rang

--
Jayanth
-----------------------------------------------------------------------
Jayanthi's Profile: http://www.excelforum.com/member.php...fo&userid=3003
View this thread: http://www.excelforum.com/showthread.php?threadid=49722