Worksheet.Names Property
Returns a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). Read-only Names object.
Syntax
expression.Names
expression A variable that represents a Worksheet object.
Remarks
Using this property without an object qualifier is equivalent to using ActiveWorkbook.Names.
Example
This example defines the name "myName" for cell A1 on Sheet1.
| Visual Basic for Applications |
|---|
|