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