Multidimensional array question.

[eduzs]

My code is something like:

Dim str1 as string, str2 as string, aMyArray
str1="A,B"
str2="C,D"
MyArray=(split(str1,","),split(str2,",",")

To retrieve the array values, I expected to use this: MyArray(0,0) should be = "A", MyArray(0,1)="B"
But I found that I can only retieve using this:
Msgbox MyArray(0)(0)
I didn't understand why it only works with "MyArray(0)(0)" and not "MyArray(0,0)" as I see everywhere?????
Is that something wrong or not ideal in my code?
Thanks.

 

[offthelip]

I get a syntax error on this line:
MyArray=(split(str1,","),split(str2,",",")
which highlights the comma between the first split and the second split. This is because what you appear to be trying to do is create an array of two single dimension arrays, i.e an array of arrays If your version of EXCEL manages to sort that out then the addressing would be as you have found. the addressing myarray(0,0) implies a single two dimension array
I am using EXCEL 2010

 

[eduzs]

Array arrays is not supported by Office 2010?
Thank you! I will need to modify the code.