Hi!

I have also had the sameproblem for a modified recorded Excel Macro.
I also needed a variable inside the on the brackets in the ActiveCell.FormulaR1C1 statement. After encountered the same...