Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Formula
How can I enter a formula with a macro that will sum all the rows above it in
that column? I need the formula to be entered into the cell 2 rows below the last row with data in that column. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Formula
Sub SumFormula()
Cells(65000, ActiveCell.Column).End(xlUp). _ Offset(2, 0).FormulaR1C1 = "=SUM(R1C:R[-2]C)" End Sub HTH. Best wishes Harald "Josh O." skrev i melding ... How can I enter a formula with a macro that will sum all the rows above it in that column? I need the formula to be entered into the cell 2 rows below the last row with data in that column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |