IsArray function

Returns a Boolean value indicating whether a variable is an array.



The required varname argument is an identifier specifying a variable.


IsArray returns True if the variable is an array; otherwise, it returns False. IsArray is especially useful with variants containing arrays.


This example uses the IsArray function to check if a variable is an array.

Dim MyArray(1 To 5) As Integer, YourArray, MyCheck    ' Declare array variables.
YourArray = Array(1, 2, 3)    ' Use Array function.
MyCheck = IsArray(MyArray)    ' Returns True.
MyCheck = IsArray(YourArray)    ' Returns True.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.