Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2005
Visual Studio
Visual Studio Tools for Office
Reference
Microsoft.Office.Tools.Excel
NamedRange Class
NamedRange Properties
AddIndent Property
Address Property
AddressLocal Property
AllowEdit Property
Application Property
Areas Property
Borders Property
Cells Property
Characters Property
Column Property
Columns Property
ColumnWidth Property
Comment Property
Count Property
Creator Property
CurrentArray Property
CurrentRegion Property
Dependents Property
DirectDependents Property
DirectPrecedents Property
End Property
EntireColumn Property
EntireRow Property
Errors Property
Font Property
FormatConditions Property
Formula Property
FormulaArray Property
FormulaHidden Property
FormulaLabel Property
FormulaLocal Property
FormulaR1C1 Property
FormulaR1C1Local Property
HasArray Property
HasFormula Property
Height Property
Hidden Property
HorizontalAlignment Property
Hyperlinks Property
ID Property
IndentLevel Property
InnerObject Property
Interior Property
Item Property
Left Property
ListHeaderRows Property
ListObject Property
LocationInTable Property
Locked Property
MergeArea Property
MergeCells Property
Name Property
Next Property
NumberFormat Property
NumberFormatLocal Property
Offset Property
Orientation Property
OutlineLevel Property
PageBreak Property
Parent Property
Phonetic Property
Phonetics Property
PivotCell Property
PivotField Property
PivotItem Property
PivotTable Property
Precedents Property
PrefixCharacter Property
Previous Property
QueryTable Property
ReadingOrder Property
RefersTo Property
RefersToLocal Property
RefersToR1C1 Property
RefersToR1C1Local Property
RefersToRange Property
Resize Property
Row Property
RowHeight Property
Rows Property
ShowDetail Property
ShrinkToFit Property
SmartTags Property
SoundNote Property
Style Property
Summary Property
Tag Property
Text Property
Top Property
UseStandardHeight Property
UseStandardWidth Property
Validation Property
Value Property
Value2 Property
VerticalAlignment Property
Width Property
Worksheet Property
WrapText Property
XPath Property
Expand Minimize
This topic has not yet been rated - Rate this topic

NamedRange.Value Property

Visual Studio 2005

Gets or sets the value of the NamedRange control.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

C#
VB
Copy 
[BindableAttribute(true)] 
public Object Value { get; set; }

Property Value

The value of the NamedRange control.

The Value property can be used with the following optional parameters. If you specify the optional parameters, you must use the set_Value and get_Value accessors in Visual Basic and C#.

Parameter

Description

RangeValueDataType

One of the XlRangeValueDataType values that specifies the data type of the range value. The default is xlRangeValueDefault.

_arg1

The value of the NamedRange control. This parameter is used only with the set_Value set accessor.

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

The following code example demonstrates how to set the Value property with and without the optional parameters.

C#
VB
Copy 
private void SetValue()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", missing],
        "namedRange1");
    namedRange1.Value = "Smith";

    Microsoft.Office.Tools.Excel.NamedRange namedRange2 =
        this.Controls.AddNamedRange(this.Range["A2", missing],
        "namedRange2");
    namedRange2.set_Value(Excel.XlRangeValueDataType.xlRangeValueDefault,
        "Jones");
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.