using variable inside formulaR1C1 for offseting

Question

I have the following line of code:

ActiveCell.FormulaR1C1 = "=sqrt(RC[-1])"

Now instead of -1, I want to use a variable, say x, as follows:

ActiveCell.FormulaR1C1 = "=sqrt(RC[x])"

This returns an error. Is there any way I can do this?

Answer 1

Like this:

ActiveCell.FormulaR1C1 = "=sqrt(RC[" & x & "])"