VBA : VBA code for summation formula

[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

 

[Debra Dalgleish]

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)"