ALEN( ) Function

Example   See Also

Returns the number of elements, rows, or columns in an array.

Syntax

ALEN(ArrayName [, nArrayAttribute])

Returns

Numeric

Arguments

ArrayName

Specifies the name of the array. If you include only the array name, ALEN( ) returns the number of elements in the array.

nArrayAttribute

Determines whether ALEN( ) returns the number of elements, rows or columns in the array according to the following values for nArrayAttribute:

0 Returns the number of elements in the array. Omitting nArrayAttribute is identical to specifying 0.
1 Returns the number of rows in the array.
2 Returns the number of columns in the array. If the array is a one-dimensional array, ALEN( ) returns 0 (no columns).