Count Property (XArrayDB)

This property returns a long integer that specifies the number of elements contained in a given dimension of an XArrayDB object.

XArrayDB.Count (nDim)

Arguments

nDim is a one-based integer specifying an array dimension.

Read-only at run time. Not available at design time.

Property applies to XArrayDB object.

The value returned is always equal to:

MyArray.UpperBound(nDim) - MyArray.LowerBound(nDim) + 1

The nDim argument should be 1 for rows and 2 for columns. A trappable error occurs if an invalid dimension is specified.

Example

The following example uses one-based row indexes (the first dimension) and zero-based column indexes (the second dimension):

MyArray.ReDim 1, 100, 0, 5

Dim N As Long

N = MyArray.Count(1) ' returns 100

N = MyArray.Count(2) ' returns 6