The IsArray function in VBA (Visual Basic for Applications) is used to determine whether a variable is an array. It returns a Boolean value: True if the variable is an array; otherwise, it returns False.

Here’s how you can use the IsArray function:

Basic Usage

Sub CheckIfArray()
    Dim notArray As Integer
    Dim isArray As Variant
    
    notArray = 10
    isArray = Array(1, 2, 3, 4, 5)
    
    ' Check if notArray is an array
    If IsArray(notArray) Then
        MsgBox "notArray is an array"
    Else
        MsgBox "notArray is not an array"
    End If
    
    ' Check if isArray is an array
    If IsArray(isArray) Then
        MsgBox "isArray is an array"
    Else
        MsgBox "isArray is not an array"
    End If
End Sub

If you run this code, you’ll see two message boxes. The first one will tell you that notArray is not an array, and the second one will tell you that isArray is an array.

Remember that in VBA, an array could either be a static array (where the size is defined at compile time) or a dynamic array (where the size can be set or changed during runtime). The IsArray function works for both of these types of arrays. Moreover, the function checks only if the variable is of array data type; it does not verify whether the array has been initialized or not.

Follow us on Social Media

facebooklinkedin

Unlock Your Potential

Excel

Access

Power BI

Help us grow the project