Gonzalo De La Torre
New Member
- Joined
- May 21, 2010
- Messages
- 24
The idea is the following:
Dim VariableRow As String
ActiveCell.FormulaR1C1 = "=SUM(RC[-2]:R[VariableRow]C[-2])"
I have values in column A but in column B i have nother value that it is going to tell the number of rows the sum is going to cover in column A Can this be done in VBA or just by using a simple formula Example:
--------------------------------Column C
Row Number|Column A|Column B|Sum Result
----1------|----1----|---3----|----8-----------Sum = Range(A1:A3)
----2------|----2----|---0----|
----3------|----5----|---0
----4------|----2----|---4----|----9-----------Sum = Range(A4:A7)
----5------|----2----|---0----|
----6------|----2----|---0----|
----7------|----3----|---0----|
Can anyone help me out with this issue?
Dim VariableRow As String
ActiveCell.FormulaR1C1 = "=SUM(RC[-2]:R[VariableRow]C[-2])"
I have values in column A but in column B i have nother value that it is going to tell the number of rows the sum is going to cover in column A Can this be done in VBA or just by using a simple formula Example:
--------------------------------Column C
Row Number|Column A|Column B|Sum Result
----1------|----1----|---3----|----8-----------Sum = Range(A1:A3)
----2------|----2----|---0----|
----3------|----5----|---0
----4------|----2----|---4----|----9-----------Sum = Range(A4:A7)
----5------|----2----|---0----|
----6------|----2----|---0----|
----7------|----3----|---0----|
Can anyone help me out with this issue?