How to turn Listobject into an Array

My spreadsheets use a lot of ListObjects (tables). This excellent article explains that importing data into an array is much faster than pulling it from the spreadsheet:

https://www.soa.org/News-and-Publica...s42-roper.aspx

I know I can make the array by saying:

Please Login or Register  to view this content.

I'm sure that this concept will help me a lot if I can just resolve these issues:

1. One of the things I like about ListObjects is how I can refer to a column by name such as:

Please Login or Register  to view this content.

Is there a way to do that in an array?


2. I can find a specific value in the table with something like this:

Please Login or Register  to view this content.

Is there a way to do that in an array?


3. How much data can the array hold reasonably? I have some tables with 17,000 rows and about a dozen columns.

Maybe something like

Please Login or Register  to view this content.

The 1st element will have the Column Name, which you can check using IF.

Hi shawnvw,

It looks like you are trying to use Structured References with Arrays... See
https://support.office.com/en-us/art...3-C8AE6D2B276E

Now, your question is how to use Structured References in VBA code? See if this link gets you closer. I've never tried it but seems like a fun adventure.
http://superuser.com/questions/47604...an-excel-macro