NamedRange.CreateNames Method (2007 System)

Creates names in the NamedRange control, based on text labels in the sheet.

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

Syntax

'Declaration
Public Function CreateNames ( _
    Top As Object, _
    Left As Object, _
    Bottom As Object, _
    Right As Object _
) As Object
'Usage
Dim instance As NamedRange 
Dim Top As Object 
Dim Left As Object 
Dim Bottom As Object 
Dim Right As Object 
Dim returnValue As Object 

returnValue = instance.CreateNames(Top, _
    Left, Bottom, Right)
public Object CreateNames(
    Object Top,
    Object Left,
    Object Bottom,
    Object Right
)
public:
Object^ CreateNames(
    Object^ Top, 
    Object^ Left, 
    Object^ Bottom, 
    Object^ Right
)
public function CreateNames(
    Top : Object, 
    Left : Object, 
    Bottom : Object, 
    Right : Object
) : Object

Parameters

  • Top
    Type: System.Object

    true to create names by using labels in the top row. The default value is false.

  • Left
    Type: System.Object

    true to create names by using labels in the left column. The default value is false.

  • Bottom
    Type: System.Object

    true to create names by using labels in the bottom row. The default value is false.

  • Right
    Type: System.Object

    true to create names by using labels in the right column. The default value is false.

Return Value

Type: System.Object

Remarks

If you do not specify one of Top, Left, Bottom, or Right, Microsoft Office Excel guesses the location of the text labels, based on the shape of the NamedRange control.

Optional Parameters

For information on optional parameters, see The Variable missing and Optional Parameters in Office Solutions.

.NET Framework Security

See Also

Reference

NamedRange Class

NamedRange Members

Microsoft.Office.Tools.Excel Namespace