Friends,

I have a double stored as "Total." 

ActiveCell.FormulaR1C1 = "=SUM(R[-32]C[15]:R[-2]C[18]) + & Total & "
I need the value of the active cell to actually be the formula and not just the result of the calculation because after this point data will be entered into the SUM range which would alter the total sum. What is the syntax to get this to work?

Thanks for the help!