Refer dynamically to a table named range in VBA

[freelensia]

Hello everybody, I am joining the forum for the first time. Hope to learn a lot from everybody and exchange useful information.

With Excel 2013 we can use Tables just as named ranges.

I am trying to refer to the Table "Extract". However, this table name may change in the future. As such, I would like to register it once as a public variable then refer to the public variable name for the rest of the Module. An example is the following:

Public ExtractTable As Range

Sub ResizeExtract()
Set ExtractTable = Range("Extract")

Range(ExtractTable.Name&"[[#Headers],[username]]").ColumnWidth = 10.75

End Sub

However I get syntax error.

Could somebody help me? Thanks!