Get the type name of an array : TypeName « Data Type « VBA / Excel / Access / Word






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

Get the type name of an array

 
Sub ArrayTest4()

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

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

End Sub








Related examples in the same category

1.Use TypeName to get the object data type
2.Get the type name
3.Check the selection type
4.Uses VBA's handy TypeName function to determine the data type of the FormulaTest variable
5.Returning the Active Window, Inspector, or Explorer
6.Loop all table definitions in Database