Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Storing a formula in a name is the same as for a range
Sub addName()
    Names.add name:="Product", RefersTo:="=OFFSET(Sheet2!$A$2,0,0,COUNTA(Sheet2!$A:$A))"
End Sub