I don’t use Excel Tables much, and not at all from VBA (where they are known as ListObjects), but that should probably change, so here are four links with comprehensive help on using Tables from VBA:
- The Spreadsheet Guru- VBA Guide to ListObject
- JKP-ADS.com – Working With Tables In Excel 2013, 2010 And 2007 (VBA)
- AnalysisTabs.com – Tables in Excel VBA
- dataprose.com – Listing Toward ListObjects
A fifth link added 14th Jan 2018:
- Cameron Wallace – Referencing ListObjects (tables) with VBA
Newton Excel Bach, not (just) an Excel Blog 
Thanks Doug, Here’s another post on dataprose.org your readers may be interested in. Best, w
http://dataprose.org/h2h-excel-range-object-versus-listobject-object/
LikeLike
Thanks Doug. Seems the link is broken. Here is the updated link to Listing Toward…. Best, w
http://dataprose.org/listing-toward-listobjects-excel-tables/
LikeLike
Thanks Winston, the link in the post is now fixed.
LikeLike
Hi Doug,
I created a blog post recently about the best ways to reference ListObjects in VBA. This is found at https://www.dingbatdata.com/2017/11/24/referencing-listobjects-with-vba/ . Table names and their column (names and indexes) can be all changed inadvertently by users, and table names will change if the sheet is duplicated (unlike named ranges). The blog post gives solutions to those problems so VBA errors can be prevented.
LikeLike
Thanks Cameron, good to see another addition to the small band of people publishing on engineering with spreadsheets. I’ll add your link to the main article.
LikeLiked by 1 person