Declare Multidimensional Arrays
You might want to consider:
Dim MultidimensionalArray(1 To 3)
MultidimensionalArray(1) = Array("a", "b", "c")
MultidimensionalArray(2) = Array("d", "e", "f")
MultidimensionalArray(3) = Array("g", "h", "i")
For i = 1 To 3: For j = 0 To 2
Debug.Print MultidimensionalArray(i)(j)
Next: Next
Alan Beban
Brent McIntyre wrote:
Good evening all,
I received some help recently regarding Multidimensional
Arrays, and now I require some more, any help you may be
able to give would be much appreciated.
I am setting out a Multidimensional Array, ie.
a b c
d e f
g h i
To do this in VBA I would type
MultidimensionalArray(1,0) = "a"
MultidimensionalArray(1,1) = "b"
MultidimensionalArray(1,2) = "c"
MultidimensionalArray(2,0) = "d"
MultidimensionalArray(2,1) = "e"
MultidimensionalArray(2,2) = "f"
MultidimensionalArray(3,0) = "g"
MultidimensionalArray(3,1) = "h"
MultidimensionalArray(3,2) = "i"
I am wanting to know if there is a quicker way to do this
with less code, ie.
MultidimensionArray(1,"a","b","c")
MultidimensionArray(2,"d","e","f")
MultidimensionArray(3,"g","h","i")
This code does not work, but I am sure there must be
similar code in VBA somewhere to do this.
Any help you may be able to provide would be much
appreciated.
Yours sincerely,
Brent McIntyre
|