Names Interface
A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<GuidAttribute("000208B8-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface Names _
Inherits IEnumerable
'Usage
Dim instance As Names
[GuidAttribute("000208B8-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface Names : IEnumerable
Remarks
Use the Names property to return the Names collection.
Use the Add method to create a name and add it to the collection. The Add method's RefersTo argument must be specified in A1-style notation, including dollar signs ($) where appropriate. For example, if cell A10 is selected on Sheet1 and you define a name by using the RefersTo argument "=sheet1!A1:B1", the new name actually refers to cells A10:B10 (because you specified a relative reference). To specify an absolute reference, use "=sheet1!$A$1:$B$1".
Use Names(index), where index is the name index number or defined name, to return a single Name object.