Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use the Evaluate method equivalent to evaluate the name in VBA
Sub itemA()
     Names.add name:="ItemsInA", RefersTo:="=COUNTA($A:$A)"
     MsgBox [ItemsInA]
End Sub