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