Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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