how RC1 formula convert to range formula Range("H11").FormulaR1C1 = "=SUM(R[-9]C:R[-1]C)" Range("H12").FormulaR1C1 = "=R[-1]C*0.04" Range("H13").FormulaR1C1 = "=R[-2]C*0.01" Range("H14").FormulaR1C1 = "=SUM(R[-3]C:R[-1]C)"