Hello,
I am trying to write a "simple" code to sum one value in a column containing values of (Q3) and add it to another which is the calculated value that I'm after (I3), in the column adjacent. How many values of Q3 that I sum depends on what another value, SP/2 is in the last column.
A code I found in easy language looks like this:
For count= 0 to Int(SP/2) -1 begin
I3=I3 + Q3(Count)
My Excel 2000 spreadsheet looks like this:
Col: AF AG AH
(Q3) (I3) (SP/2)
.03
.02
.05
.04
.06 X 4
.07 X1 3
. . .
. . .
.01 Xn 6
I want to be able to calculate I3 for x, x1 and...... xn
How do I do this in VBA? Could you please also show me how you would declare the variables as well. I am just starting out in this, and if you could point me in the right direction I'd appreciate it.
Thanks
LS
I am trying to write a "simple" code to sum one value in a column containing values of (Q3) and add it to another which is the calculated value that I'm after (I3), in the column adjacent. How many values of Q3 that I sum depends on what another value, SP/2 is in the last column.
A code I found in easy language looks like this:
For count= 0 to Int(SP/2) -1 begin
I3=I3 + Q3(Count)
My Excel 2000 spreadsheet looks like this:
Col: AF AG AH
(Q3) (I3) (SP/2)
.03
.02
.05
.04
.06 X 4
.07 X1 3
. . .
. . .
.01 Xn 6
I want to be able to calculate I3 for x, x1 and...... xn
How do I do this in VBA? Could you please also show me how you would declare the variables as well. I am just starting out in this, and if you could point me in the right direction I'd appreciate it.
Thanks
LS