IsArray function

Category: Array / Information

Summary

True if variable is array.

Syntax

IsArray(varname) The required varname argument is an identifier specifying a variable.

Example

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.

Microsoft Support Page

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/isarray-function

Back to Functions