Going through each item in a sheet
 

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

Going through each item in a sheet
 

Range("A1").Select
NosOfItems = Range(Selection, Selection.End(xlDown)).Count

NosOfItems gives the required number

- Manges

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