how to sum with spesific range ?
i try with this syntax but it's not work

ActiveCell.FormulaR1C1 = "=SUM(R[" & -ActiveCell.Row + 1 & "]C:R[-1]C)"

thanks