Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array of arrays stored in Name: POSSIBLE?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
array of arrays stored in Name: POSSIBLE?
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 wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions, Arrays and number/text stored as text | Excel Worksheet Functions | |||
Passing an array or recordset to a stored procedure | Excel Programming | |||
Passing an array or recordset to a stored procedure | Excel Programming | |||
Passing an array or recordset to a stored procedure | Excel Programming | |||
vba clearing out values stored in array | Excel Programming |