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