Dynamic multidimensional array definition

**BrianAll** · 11-13-2013, 12:54 PM

Hello,

does anyone know if it is possible to dynamically declare a multidimensional array?
I was thinking about something like:

Dim VariableNumber as Integer
Dim Array(1 To 5, 1 To VariableNumber) As Variant

VariableNumber = 10

Thank you

**ragulduy** · 11-13-2013, 12:57 PM

Dim a(0,0) as variant
variablenumber = 10
redim a(5,variablenumber)

I think. You use the redim statement anyway, have a look in the help if that doesn't work.

**shg** · 11-13-2013, 12:58 PM

    Dim n As Long
    Dim av As Variant
    
    n = 10
    ReDim av(1 To 5, 1 To n)

Array is a native VBA function -- you don't want to use that as a variable name.

Re: Dynamic multidimensional array definition