Add the name to the Names collection associated with the worksheet, which only includes the names that are local to that worksheet : Name Create « Excel « VBA / Excel / Access / Word






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

Add the name to the Names collection associated with the worksheet, which only includes the names that are local to that worksheet

 
Sub nameRef()
     Worksheets("Sheet1").Names.add name:="Costs", RefersTo:="=Sheet1!$F$10:$F$12"
End Sub
'Using the Name Property of the Range Object
Sub name()
     range("A1:D10").name = "SalesData"
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.Create a local name
3.renames an existing name:
4.Create a name based on a Range
5.Define a name by referring a workbook
6.Define a name by referring the selection cell address