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

Loop to acces various rows
 

Try something like

i = 1
total = 0

Do While i < 10
total = total + Range("G" & i).Value
i = i + 1
Loop



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mhek" wrote
in message
...

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