What could UBound = -1 mean?

Question

Hello,

I have a 1-dimensional array (say 0 To 10) which I "emptied" using:

vIntermediate1_1D = Array()

I had the curiosity to use MsgBox to check what are the LBound and UBound of my array after emptying:

I got:
LBound = 0
UBound = -1

I am puzzled: What could an UBound of -1 mean?

How can the array be like this: vIntermediate1_1D (0 To -1)?

Thanks for bringing some light.

Leon

Answer 1

You can see the doc UBound Function (Visual Basic) :

Return Value

Integer. The highest value the subscript for the specified dimension can contain. If Array has only one element, UBound returns 0. If Array has no elements, for example if it is a zero-length string, UBound returns -1.