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





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

1.Is a variable an array