Assigning/Retrieving arrays of values to/from listobjects

How can I add an array of values to a listobject, preferably in one big chunk? How can I read a chunk of values from a listobject into an array?

For the latter, I've tried:

Please Login or Register  to view this content.

but it just doesn't work.

Thanks,
Jarrod

Hello jarrods,

You need to make one small change to your code. Remove the Set statement. You're assigning an array of values to your variable, not an object. With this array, the first subscript of each dimension is one, not zero. As for the second part of your question, I have had no success. Nearly all the properties are Read Only. Can't expand a range when it is read only.

Please Login or Register  to view this content.