NamedRange.CreateNames Method
Creates names in the NamedRange control, based on text labels in the sheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Function CreateNames ( _
Top As Object, _
Left As Object, _
Bottom As Object, _
Right As Object _
) As Object
Object CreateNames(
Object Top,
Object Left,
Object Bottom,
Object Right
)
Parameters
Top
Type: System.Objecttrue to create names by using labels in the top row. The default value is false.
Left
Type: System.Objecttrue to create names by using labels in the left column. The default value is false.
Bottom
Type: System.Objecttrue to create names by using labels in the bottom row. The default value is false.
Right
Type: System.Objecttrue 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 Optional Parameters in Office Solutions.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.