Posted 8 September 2017, 3:15 pm EST

Hello,In the first cell of a column, I would like to put a formula that calculates the SUM of this column from line 2 (Row 1) to the final row of the sheet (. ROWCOUNT)

**But this value changes**because the end user can insert rows.

I can do this programmatically

Dim MyFormula = "SUM(R1C: R" & FP.ActiveSheet.RowCount & "C"

FP.ActiveSheet.SetFormula (0, 2, MyFormula)

But this is not what I want

I want to register directly in the Spread designer or in the relevant cell (AllowUserformula is true) the correct formula and, after, save the spread.

The Rows function "Rows(C: C)" which gives the value of RowCount does not help me much in this case.

Is there a way to do this?

Thank you

Stephane

(Translated by Google)