Posted 8 September 2017, 3:15 pm ESTHello,
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?
(Translated by Google)