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

--
HTH

Bob Phillips

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

"Trever B" wrote in message
...
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