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:

Please Login or Register  to view this content.

[JosephP]

the array boundaries start at 0 so

Please Login or Register  to view this content.

[wizuriel]

the array boundaries start at 0 so

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.