Array of arrays Declaration

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ibrahima - 23 May 2005 09:50 GMT

Hello,

When declaring an array of array, let say:

dim arrTable()() as Variant

I get a message box:" Compile error, expected : end statement"
Thanks in advance for your support.
Ibrahima.

Reply to this Message

Norm Cook - 23 May 2005 14:29 GMT

Try this code:

Private Sub Form_Load()
Dim a(1 To 2) As Variant
Dim s1(1 To 5) As String
Dim s2(1 To 5) As String
Dim i As Long
For i = 1 To 5
s1(i) = "StringArray1 Element " & i
s2(i) = "StringArray2 Element " & i
Next
a(1) = s1
a(2) = s2
Debug.Print a(1)(1), a(1)(5)
Debug.Print a(2)(1), a(2)(5)
End Sub

> Hello,
>
[quoted text clipped - 5 lines]
> Thanks in advance for your support.
> Ibrahima.

Reply to this Message

VB Forum / COM / May 2005

Array of arrays Declaration