Cell Formula help

[Trever B]

Hi,

Thanks in advance,

Can you please help me.

Is says sub not found. Please help me to put following statement right

Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=" & Address(2, 3, 1, False,
"Sheet1")



Thanks

Trev

 

[Bob Phillips]

Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=R2C3"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Trever B]

Thanks bob but you missed that it refers to sheet1 and not current sheet

 

[Dave Peterson]

Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=Sheet1!R2C3"