Loop to acces various rows

[Mhek]

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

[Chip Pearson]

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" <[email protected]> wrote
in message
news:[email protected]...
>
> 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
>