View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajitpalsingh200[_8_] ajitpalsingh200[_8_] is offline
external usenet poster
 
Posts: 1
Default Going through each item in a sheet


Guys,,

I have a question here...

Lets say i have a list of item in A1.

for example. A1 to A20 have a list of names..


Just assume that we dont know how many list of items i have there..
How do i set the for loop so that it goes through all the items in A
till the last item.

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