array of arrays stored in Name: POSSIBLE?

[matthewgdodds]

Folks,

I've been using JohnGreen's method of storing an array in a worksheet
name perfectly succesfully but would like to extend this to storing an
array which itself has an array in each index position.

Can anyone tell me whether this is possible or not? My attempts so far
have proved fruitless but I know there's a lot of expertise out there
....

In hope, as always, and with Festive Salutations to All

Matthew

 

[Peter T]

Hi Matthew,

Do you mean define an array of arrays as a name? If so I don't see how that
would be possible, but I would be interested to be wrong!

AFAIK a defined array needs to be similar to what you can pass to a range. A
single horizontal dimension (one row of values) or 2 dimensions (rows &
columns of values). Then in cell formulas you can array enter the named
array, or (say) return individual elements, eg =index(myarray,row,col)

Let's imagine you can define an array of arrays, how would you access these
additional elements. Couldn't do as in vba, x = myarray(1,2)(1,2), at least
I don't think so.

What's your overall intention? Perhaps there's a different approach.

Regards,
Peter