The VBA guide to ListObject Excel tables

For a data analyst, Excel Tables are a necessity! They are the most efficient way to organize your raw data and refer to data that contracts/expands on a regular basis.

Likewise, Excel tables can be extremely useful in combination with VBA. I personally use data tables as a way to store user settings without having to modify any VBA code.

In this article I wanted to bring all the common ways of referencing table data with VBA into one place.