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). |