In VBA Excel how we can write the following formula =SUM($A$1:$A$10 programatically by using the FormulaR1C1 ? ex: ActiveCell.FormulaR1C1 = “=RC[-1]/R[1]C[-1]” ?
