Names Property (2007 System)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Workbook.Names Property (2007 System)

Gets a Names collection that represents all the names in the workbook (including all worksheet-specific names).

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

[BrowsableAttribute(false)]
public Names Names { get; }

Property Value

Type: Names
A Names collection that represents all the names in the workbook (including all worksheet-specific names).

The following code example uses the Names property to create three Name objects that refer to different ranges on worksheet Sheet1. The example then iterates through every Name in the workbook and displays the names in column A of worksheet Sheet1.

This example is for a document-level customization.

private void DisplayWorkbookNames()
{
    this.Names.Add("Name1", Globals.Sheet1.Range["B1", "B5"], true, missing,
        missing, missing, missing, missing, missing, missing, missing);
    this.Names.Add("Name2", Globals.Sheet1.Range["C1", "C5"], true, missing,
        missing, missing, missing, missing, missing, missing, missing);
    this.Names.Add("Name3", Globals.Sheet1.Range["D1", "D5"], true, missing,
        missing, missing, missing, missing, missing, missing, missing);

    for (int i = 1; i <= this.Names.Count; i++)
    {
        Globals.Sheet1.Range["A" + i.ToString(), missing].Value2 =
            this.Names.Item(i, missing, missing);
    }
}

Show:
© 2016 Microsoft