The variable type of an array and an integer : varType « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. varType

The variable type of an array and an integer

 

Sub ArrayTest2()
    Dim intNum1 As Integer
    Dim intNum(1 To 10) As Integer

    Debug.Print "intnum1: " & VarType(intNum1)
    Debug.Print "intnum: " & VarType(intNum)

End Sub








Related examples in the same category

1.Check the variable type
2.Check the variable type: integer and integer array
3.Values returned by the VarType function