Tables and VBA

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:

A fifth link added 14th Jan 2018:

This entry was posted in Arrays, Excel, VBA and tagged , , , , . Bookmark the permalink.

5 Responses to Tables and VBA

  1. 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/

    Like

  2. 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/

    Like

  3. Cameron Wallace says:

    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.

    Like

    • dougaj4 says:

      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.

      Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.