Hello.

I've been trying to use vba to input a formula into a cell and then offset the reference cell for each subsequent loop.

What I have is:

ActiveCell.FormulaR1C1 = "=offset(Summary!R[4]C[2],25*i,0)"


This gives me #NAME? error and I'm not sure how to fix it.