Data Type VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Data Type
  4. Uses VBAs 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