Get started for free
Developer Tools and Languages
Visual Studio 2010
Visual Studio
Office Development in Visual Studio
Reference
Managed Reference (Office Development in Visual Studio)
Microsoft.Office.Tools.Excel
NamedRange Interface
NamedRange Methods
_PasteSpecial Method
_PrintOut Method
Activate Method
AddComment Method
AdvancedFilter Method
AllocateChanges Method
ApplyNames Method
ApplyOutlineStyles Method
AutoComplete Method
AutoFill Method
AutoFilter Method
AutoFit Method
AutoFormat Method
AutoOutline Method
BorderAround Method
BorderAround2 Method
Calculate Method
CalculateRowMajorOrder Method
CheckSpelling Method
Clear Method
ClearComments Method
ClearContents Method
ClearFormats Method
ClearHyperlinks Method
ClearNotes Method
ClearOutline Method
ColumnDifferences Method
Consolidate Method
Copy Method
CopyFromRecordset Method
CopyPicture Method
CreateNames Method
CreatePublisher Method
Cut Method
DataSeries Method
Delete Method
DialogBox Method
Dirty Method
DiscardChanges Method
EditionOptions Method
ExportAsFixedFormat Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method
Find Method
FindNext Method
FindPrevious Method
FunctionWizard Method
get_Address Method
get_AddressLocal Method
get_Characters Method
get_End Method
get_Item Method
get_Offset Method
get_Range Method
get_Resize Method
get_Value Method
GetEnumerator Method
GoalSeek Method
Group Method
Insert Method
InsertIndent Method
Justify Method
ListNames Method
Merge Method
NavigateArrow Method
NoteText Method
Parse Method
PasteSpecial Method
PrintOut Method
PrintOutEx Method
PrintPreview Method
RemoveDuplicates Method
RemoveSubtotal Method
Replace Method
RowDifferences Method
Run Method
Select Method
set_Item Method
set_Value Method
SetPhonetic Method
Show Method
ShowDependents Method
ShowErrors Method
ShowPrecedents Method
Sort Method
SortSpecial Method
Speak Method
SpecialCells Method
SubscribeTo Method
Subtotal Method
Table Method
TextToColumns Method
Ungroup Method
UnMerge Method
Expand Minimize
This topic has not yet been rated - Rate this topic

NamedRange.CreateNames Method

Visual Studio 2010

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)
C#
VB
Copy 
Object CreateNames(
	Object Top,
	Object Left,
	Object Bottom,
	Object Right
)

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

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.