Array With Multiple Sub Arrays - is it possible?

[fat-tony]

Hi Guys,

Got a fun new question about arrays today.

I have an array:

MainArray(1 to 25)

What I am hoping to get is the following:

MainArray(1 to 25).SubArray1(1 to 3, 1 to 10)
MainArray(1 to 25).SubArray2(1 to 6, 1 to 5)
MainArray(1 to 25).SubArray3(1 to 3, 1 to 5)
MainArray(1 to 25).SubArray4(1 to 4, 1 to 15)

I have it working with one Sub Array only at present:

Option Base 1

Private Type arrayType
    SubArray1() As String
End Type

Sub Array_Array()
    Dim TLArray(25) As arrayType
    For i = 1 To 25
        ReDim Preserve TLArray(i).SubArray1(3, 10)
    Next i
    For i = 1 To 25
       For x = 1 To 3
          For y = 1 To 10
              TLArray(i).SubArray1(x, y) = "Stuff Goes Here"
          Next y
       Next x
    Next i
End Sub

Opening this up for any advice and dicussion thanks.

 

[fat-tony]

I am currently playing with a few versions. will post here. Hopefully may be of use to some people

 

[RoryA]

Not really clear to me what the issue is - can't you just add the other arrays to your Type declaration?

 

[fat-tony]

Not really clear to me what the issue is - can't you just add the other arrays to your Type declaration?

Yeh thats the current way I was doing it which is why I posted that method to get the ball rollling with 1 sub array. The thread was more of forum for discussing how other people use Excel and VBA to achieve the same goal.

 

[kpark91]

Is there any reason why you would want to have subarrays instead of just having a three-dimensional array?

Sub Array_Array()
    Dim TLArray() As String
    For i = 1 To 25
        ReDim Preserve TLArray(25, 3, 10)
    Next i
    For i = 1 To 25
       For x = 1 To 3
          For y = 1 To 10
              TLArray(i, x, y) = "Stuff Goes Here"
          Next y
       Next x
    Next i
End Sub

You wouldn't even need to declare a type..

 

[RoryA]

By using a 1D array of a Type, you can redim preserve that array as you encounter more items. If you use a multidimensional array you can only redim the last dimension if you want to Preserve the contents.

 

[kpark91]

If you use a multidimensional array you can only redim the last dimension if you want to Preserve the contents.

D: Enlightenment!!!
Thank you very much!!