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:

Please Login or Register  to view this content.

However I get syntax error.

Could somebody help me? Thanks!

[jindon]

Something like

Please Login or Register  to view this content.

[kev_]

Please Login or Register  to view this content.

here's a helpful link to help explain ListObjects in Excel Tables