Data Type VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Data Type
  4. Use TypeName to get the object data type
Sub TypeSheet()
    MsgBox "This sheet is a " & TypeName(ActiveSheet)
End Sub