Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Create a global name that refers to a range using the Add method of the Workbook objects Names collection
Sub add()
     Names.add name:="Data", RefersTo:="=Sheet1!$D$10:$D$12"
End Sub