Variable in ActiveCell.FormulaR1C1?

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.

This works! Thanks!!

Say I want to anchor R[4]C[2], how could I do this? When my code runs down the columns I get D8, D9, D10. I want it all to reference D8 though.

    For i = 0 To 9
    ActiveCell.FormulaR1C1 = "=offset(Summary!R[4]C[2]," & 25 * i & ",0)"
    ActiveCell.Offset(1, 0).Select
        Next i

Edit: My current code

Works perfect! Thanks