Putting a dynamic array in a dictionary

[wizuriel]

Is it possible to put a dynamically calculated array in a VBA dictionary?

What I have now is:

    Dim data As Object
    Dim Size As Integer 'for example it is actually a dynamically calculated number
    
    Set data = CreateObject("scripting.dictionary")
    Size = 3
    If Not (data.exists(5)) Then
        data.Add (5), Array(Size)
    End If
    
    data(5)(1) = 1  'gives a subscript out of range error

[JosephP]

the array boundaries start at 0 so

data(5)(0) = 1

[wizuriel]

the array boundaries start at 0 so

data(5)(0) = 1

But I'm in theory setting the UBound to 3 so (1) should still exists and not give me that error

[JosephP]

no you are not-you are adding a one element array containing the value 3 to the dictionary. if you want to create a dynamic array you don't use the Array operator you declare a dynamic array and then resize it

Dim somearray()
redim somearray(size)
data.add 5, somearray