Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Create a local name
Sub localDemo()
     Names.add name:="Sheet1!Sales", RefersTo:="=Sheet1!$E$10:$E$12"
End Sub