Using the IsArray Function : IsArray « Data Type Functions « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Data Type Functions
3. IsArray

Using the IsArray Function

 
Sub IsThisArray()
    Dim tblNames() As String
    Dim totalTables As Integer
    Dim counter As Integer

    totalTables = 10

    ReDim tblNames(1 To totalTables)

    If IsArray(tblNames) Then
         MsgBox "The tblNames is an array."
    End If
End Sub

 

Related examples in the same category