Uses VBA's handy TypeName function to determine the data type of the FormulaTest variable : TypeName « Data Type « VBA / Excel / Access / Word






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

Uses VBA's handy TypeName function to determine the data type of the FormulaTest variable

 
Sub hasFormula()
    Dim FormulaTest As Variant
    FormulaTest = range("A1:A2").hasFormula
    If TypeName(FormulaTest) = "Null" Then MsgBox "Mixed!"
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.Get the type name of an array
5.Returning the Active Window, Inspector, or Explorer
6.Loop all table definitions in Database