Share via


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)

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Names As Names
'Usage
Dim instance As Workbook 
Dim value As Names 

value = instance.Names
[BrowsableAttribute(false)]
public Names Names { get; }
[BrowsableAttribute(false)]
public:
property Names^ Names {
    Names^ get ();
}
public function get Names () : Names

Property Value

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

Examples

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 Sub DisplayWorkbookNames()
    Me.Names.Add("Name1", Globals.Sheet1.Range("B1", "B5"), _
        True)
    Me.Names.Add("Name2", Globals.Sheet1.Range("C1", "C5"), _
        True)
    Me.Names.Add("Name3", Globals.Sheet1.Range("D1", "D5"), _
        True)

    Dim i As Integer 
    For i = 1 To Me.Names.Count
        Globals.Sheet1.Range("A" & i.ToString()).Value2 = _
            Me.Names.Item(i)
    Next i
End Sub
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);
    }
}

.NET Framework Security

See Also

Reference

Workbook Class

Workbook Members

Microsoft.Office.Tools.Excel Namespace