Redim an array within an array

Can I redim an array that is held within an array?

I have (for example) 3 worksheets, and from each one I want to load 2 columns into an array.
However I also want (I think) those 3 arrays to be contained within one array so that I can step through them easily.

The code below will not run, but might better show what I am wanting;

Please Login or Register  to view this content.

I'm just not sure how to reference the array within an array in order to redim it, (if it is possible?)

thanks

You would need to assign the array to a variable, redim and then load back into the container array. Based on that code though, I don't see the point in putting the dynamic arrays into the container array before you have populated them?

There is more to the actual code than this shows, but this example was the simplest way I could think to show what I was trying to achieve. Based on your reply on another thread as well I am going to rethink this now anyway

Thanks again!