Adding single listobject, selected Columns[Name] to an array

Hi

I'd like a little help please, I've been googling for half an hour and can't find it online

I can assign all values in my listobject to an array like so

Please Login or Register  to view this content.

But what if I want to create my array using only a few listobject columns, referred to by name

Is it possible to create an array in which for example

• First column: Range(mytable.Name & "[First Name]")
• Second column: Range(mytable.Name & "[Second Name]")
• Third Column: Range(mytable.Name & "[Other Column]")

They all have the same number of rows, its all from one column

Reason, I'd like to be able to control which columns go in to which column of the array, and for them to be added by name so that if I insert a column later on it won't break my vba

Trying currently, not working

Please Login or Register  to view this content.

It's possible. The for loop will show you the data that is stored. Adjust the table/column name to match yours.
Try this:

Please Login or Register  to view this content.