array of string arrays?

General
1

How does one declare an array of string arrays?

dim myListBox(-1) as string()

That didn’t work…

2

dim s() as String s = split(myListBox.cell(-1, -1), EndOfLine)

3

you can use

  • multi dimension array
  • array of class holding string array
  • array of variant and put in array of string
4

[code]Dim arrayOfStringArrays() As Variant

Dim arrayOfStrings1() As String = Array(“abc”, “def”, “ghi”)
Dim arrayOfStrings2() As String = Array(“012”, “345”, “789”)

arrayOfStringArrays.Append(arrayOfStrings1)
arrayOfStringArrays.Append(arrayOfStrings2)[/code]

5

You dont
There are no “arrays of arrays”