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