Why do I get a "Application or object-defined error" from ForumalRaC1
assignment?

Public Sub InsertLinkedTableTitle()
Dim RA As Range
Set RA = ActiveSheet.Range("A1")
RA.FormulaR1C1 = "='Table S' &'Title Page'!D2"
End Sub

"Table S" is a string value. 'Title Page' is the name of a sheet.

If FormulaR1C1 cannot handle a compounded string and cell link. how can I
assign such a formula to a cell?

Thanks.

John Wirt

How can 'Table S' be a string value? I've never seen a variable that
contained a space. To link variable data, and text data, you have to
seperate you quotes.

RA.FormulaR1C1 = "=" & TableS & "'Title Page'!D2"



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

instsead of D2 try r2c4 .



John Wirt wrote in message
...
Why do I get a "Application or object-defined error" from ForumalRaC1
assignment?

Public Sub InsertLinkedTableTitle()
Dim RA As Range
Set RA = ActiveSheet.Range("A1")
RA.FormulaR1C1 = "='Table S' &'Title Page'!D2"
End Sub

"Table S" is a string value. 'Title Page' is the name of a sheet.

If FormulaR1C1 cannot handle a compounded string and cell link. how can I
assign such a formula to a cell?

Thanks.

John Wirt