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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill" wrote in message
k.net...
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.