Cell Formula

[Bill]

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.

 

[Guest]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Dave Peterson]

One more:

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

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.