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.

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.

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.

One mo

Cells(10, 2).Formula = "=B" & FR


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.

--

Dave Peterson