VBA: Getting a table into an array

[veldthui]

I am trying to pull data from a table into an array in VBA but am unsure how to get the table data. Previously I just used a range and loaded the range straight into the array but now want to change to a table format but cannot get the data into the array.

Any help appreciated.

 

[Norie]

Use the range of the table.

arrTable = Range("Table1").Value

 

[veldthui]

Use the range of the table.

arrTable = Range("Table1").Value

That is what I used but it was returning an error. I have tried it again and it now seems to work with all but one table. Maybe something in the table is causing the issue so will redo the table and see how it goes.

Cheers

 

[Norie]

What was the error?