Trouble Including Variables in R1C1 VBA Code...

Friends,

I have a double stored as "Total."

Please Login or Register  to view this content.

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!

Try the following:

ActiveCell.FormulaR1C1 = "=SUM(R[-32]C[15]:R[-2]C[18]) +" & Total