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:
However I get syntax error.![]()
Public ExtractTable As Range Sub ResizeExtract() Set ExtractTable = Range("Extract") Range(ExtractTable.Name&"[[#Headers],[username]]").ColumnWidth = 10.75 End Sub
Could somebody help me? Thanks!
Bookmarks