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

Trever B wrote:

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

"Bob Phillips" wrote:

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




--

Dave Peterson