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 |
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 |
All times are GMT +1. The time now is 07:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com