Cell Formula help
 

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

Cell Formula help
 

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

Cell Formula help
 

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

Cell Formula help
 

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