Date: Fri, 25 Feb 2005 02:03:54 -0800
Reply-To: sylink <xtianlaw@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: sylink <xtianlaw@YAHOO.COM>
Organization: http://groups.google.com
Subject: Value summation In Excel VB
Content-Type: text/plain; charset="iso-8859-1"
I am finding it difficult to do cummulation of values in Excel using
the VBA. I'll like to loop the amount column using the notation -
cells(i,j).
Essentially what I need is the ability to add two cells using the above
notation to enable me iterate through a counter.
In other words, modify the expression below using the correct syntax.
cells(i,6) = cells(i-1,2) + cells(i,2)
|