Error while calling a 2D Array in VBA

[Shameem Khan]

Hello,

I am having trouble calling an 2D array element after I have initialized it. It is showing "Subscript out of Range". I am sure it is a simple error. Please help !!

Private Sub UserForm_Initialize()

Dim arr() As Variant
arr = Array(Array("Jan", 1), Array("Feb", 2), Array("Mar", 3))
MsgBox arr(0, 0)

End Sub

 

[Fluff]

You are using a jagged array, not a normal 2D array you you refer to it like

MsgBox arr(0)(0)

 

[Shameem Khan]

You are using a jagged array, not a normal 2D array you you refer to it like

MsgBox arr(0)(0)

Wow !! I am so stupid. I knew it was something simple. Thanks for the quick reply.

 

[Fluff]

You're welcome & thanks for the feedback.