VBA : VBA code for summation formula

  • Thread starter Thread starter david2004
  • Start date Start date
D

david2004

Hi all

I need a VBA code for a summation formula. I have a column of value
which are calculated by a formula.But the value of the second cel
below the 1st cell in the column is a summation of the calculated valu
in the 1st + 2nd cell of the same column and the 3rd cell below the to
is a summation of the 3 calculated values and subsequently for a colum
of 10 rows.
Each cell in the column uses the same formula with input according t
the row in ascending order.

Can any experts out there pls give me some help.Urgent. Thx.
:confused: :confused: :confused
 
The following code will enter a SUM formula that totals from Row 2 to
the row above the active cell:

ActiveCell.FormulaR1C1 = "=SUM(R2C:R[-1]C)"
 
Back
Top