Excel VBA IsArray Function

VBA IsArray Function: The IsArray function in VBA returns a Boolean, showing whether the given variable is an Array or not.

Syntax

IsArray (VarName)

Parameter

VarName (required)- This parameter represents the variable that you want to test.

Return

This function returns a Boolean value TRUE if the specified variable is an Array else it returns False.

Example 1

Sub IsArray_Example3()
 Dim names(5) As String
 Dim is_Array As Boolean
 is_Array = IsArray(names)
 ' The variable will return True.
 Cells(1, 1).Value = "The is_Array will return"
 Cells(1, 2).Value = is_Array
 End Sub 

Output

The is_Array will return

TRUE

Example 2

Sub IsArray_Example2()
 Dim Vals() As Integer
 Dim is_Array As Boolean
 is_Array = IsArray(Vals)
 ' The variable will return True.
 Cells(1, 1).Value = "The is_Array will return"
 Cells(1, 2).Value = is_Array
 End Sub 

Output

The is_Array will return

TRUE