IsArray

Return TRUE if the expression is an array, otherwise return FALSE.

Syntax
      IsArray(expression)

Key
   expression    A variable.

The IsArray() function may be used in VBA.

Examples

Dim ArrMonths(1 To 12) as Integer
Dim boolCheck
boolCheck = IsArray(ArrMonths)
 Returns True

Dim ArrDays, boolCheck
ArrDays = Array(1,2,3,4,5,6,7)
boolCheck = IsArray(ArrDays)
 Returns True

“Days of absence, sad and dreary, Clothed in sorrow's dark array, Days of absence, I am weary; She I love is far away” ~ William Shakespeare

Related:

IsNull - Is expression NULL? True/False


© Copyright SS64.com 1999-2014
Some rights reserved