Thread: Loop to acces various rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mhek Mhek is offline
external usenet poster
  
Posts: 1
Default Loop to acces various rows

I want to do a loop like that (for example)

i=1
Total = 0

Do While i<10
Total = Total + Range(Gi).Value
i=i+1
Loop

I know this isn't the right way to do it, but that is exactly why I'm
asking you !

How can I proceed to acces Range(G'i') to loop in many rows ?

Thanks

Frank


--
Mhek
------------------------------------------------------------------------
Mhek's Profile: http://www.excelforum.com/member.php...o&userid=33427
View this thread: http://www.excelforum.com/showthread...hreadid=532439

Reply With QuoteReply With Quote