Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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