Solved: Multidimensional Array

[asingh]

Hi,

How do I declare a multidimensional array [2--way] in VBA..??

thanks..

asingh

[Bob Phillips]

Depends upon how you want to populate it.

You can dimension it in the declaration

[vba]
Dim ary(1 To 3, 1 To 5)
[/vba]

or just declare it as variant and redim later

[vba]
Dim ary

ReDim ary(1 To 3, 1 To 5)
[/vba]

[rory]

You can also declare it as a specific datatype in the Dim statement, or declare as a variant and then specify the type in the Redim. You cannot however declare an array as one type in the Dim statement and then change type in the Redim.

[unmarkedhelicopter]

Or you could define a UDT then declare an array as that (saves memory)

[RECrerar]

Currently just for interests sake, what's a UDT?

[rory]

It's a User Defined Type. And while you could do that, I don't know why you would in most cases.

[Bob Phillips]

Nor I. They are a good idea that has been badly implemented, so personally I avoid them. I would use a class over a UDT every time.

[rory]

Likewise, though I believe the VB.Net and VB 2005 implementation of them (structures) is much better.

[asingh]

thanks...all...!

regards, asingh