2D Array -- What's Wrong with This?

[Ellpee]

Why does this give me a subscript out of range error on the second line? Seems super-simple, so I must be having a brain fart. Just trying to understand how to put values in the array and then get them out …..


Public Sub Testing3()
Dim TestArray(5, 2) As Variant
TestArray(0, 0) = 5
TestArray(0, 1) = "Fish"


Debug.Print TestArray(0, 1) & " " & TestArray(0, 2)
End Sub

[ranman256]

It may be 1 based and not 0 based: testarray(1,1) = 5
also, use collections. Arrays died in the 90s.

[ssanfu]

I do not get an error when I execute Sub Testing3().
Also, there is no data in TestArray(0, 2) - it is empty.

[Ellpee]

Big Duhhh to me, had set up a small db for testing and set it to base 1. And yes, nothing in 0,2, cause it doesn't exist. Thanks to both for breaking my brainlock.