IsArray function
Returns a Boolean value indicating whether a variable is an array.
Syntax
IsArray(varname)
The required varname argument is an identifier specifying a variable.
Remarks
IsArray returns True if the variable is an array; otherwise, it returns False. IsArray is especially useful with variants containing arrays.
Example
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.