Creating a formula using the loop variable

[Spector]

Thank you so much!

Here's what I ended up actually using:
With ActiveCell
For ii = 1 To rowCnt - 1
.Offset(rowCnt, ii).FormulaR1C1 = "=R[" & ii - rowCnt & "]C[" & -1 - i
& "] "
Next
End With

alla

 

[Bob Phillips]

That won't work whichever cell you are in, the other does.