Getting Average of a Table Column

[BrianExcel]

I need to find and assign the average of a specific column within a table called "Sum7EditsTable" so I can then pass that into a text box.

I have the following formula, which is a copycat of some other calculations I am doing to generate a graph, but for some reason this just returns a blank value.

How do I get the average of a table column using the header as opposed to doing a full-on rows.count formula to get the last cell, etc.?

ActiveWorkbook.Names.Add Name:="sAverage", RefersToR1C1:="=AVERAGE(Sum7EditsTable[[#All],[Percent Edit]])"

 

[BrianExcel]

Clarification: right now the formula above simply adds that range as a chart element.

I want to use a similar method (calling the table column by name) to get the average of that column so I can include in a text box, msgbox, etc.