Insert Formula Referencing Table Column (using String Variable) in Excel VBA

[CK Zhien]

Hi, I wanted to insert a formula that calculates the sum of a column in a table.

Cells(5,6).FormulaR1C1 = "=SUM(TableName[Score])"

However, the code doesn't work because TableName is a string variable, I need it to be that way so that i can generate multiple tables with different names. Anyone knows how to do it?

 

[Fluff]

Hi & welcome to MrExcel.
How about

   Dim TblName As String
   TblName = "Table1"
   Range("F5").Formula = "=sum(" & Tbl & "[score])"