Create a local name : Name Create « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Name Create

Create a local name

 
Sub localDemo()
     Names.add name:="Sheet1!Sales", RefersTo:="=Sheet1!$E$10:$E$12"
End Sub








Related examples in the same category

1.create a global name that refers to a range using the Add method of the Workbook object's Names collection
2.renames an existing name:
3.Create a name based on a Range
4.Add the name to the Names collection associated with the worksheet, which only includes the names that are local to that worksheet
5.Define a name by referring a workbook
6.Define a name by referring the selection cell address