Thankx you very much magesh..But i hv one more ques here..

How do it get the number of items in the list..

For example lets say Cell A have 20 items...How do i write a code t
find out the number of items in cell A

thankx agai

--
ajitpalsingh20
-----------------------------------------------------------------------
ajitpalsingh200's Profile: http://www.excelforum.com/member.php...fo&userid=1615
View this thread: http://www.excelforum.com/showthread.php?threadid=27586