Hi
When the final formula is of the form =R[2]c, the row will be offset by the
number inside the square brackets and column will remain the same. If you
want to fix the row to be 3 then your final formula should read =R3c.
Hence "= r" & FR & "c" should work.
Alok

"Bill" wrote:

Hello,
I want to put a formula in a cell based on an actual row or column number.
I tried this, where FR = 3 in the code.

Cells(10 2).FormulaR1C1 = "= r[" & FR & "]c"

It gives me =B17 in the cell, not =B3 as I want.

Any help?

Thanks.