IsArray

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

Syntax
      IsArray(expression)

Key
   expression    A variable.

The IsArray() function can 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