set_Value Method
Collapse the table of content
Expand the table of content

NamedRange.set_Value Method (Object, Object)


Sets the value of the NamedRange control.

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

void set_Value(
	object rangeValueDataType,
	object arg1


Type: System.Object

One of the T:Microsoft.Office.Interop.Excel.XlRangeValueDataType values that specifies the data type of the range value. The default is F:Microsoft.Office.Interop.Excel.XlRangeValueDataType.xlRangeValueDefault. This parameter is optional in Visual Basic.


The value of the NamedRange control. This parameter is optional in Visual Basic.

If you do not need to specify the optional parameters, you can use the Value property instead of this method.

For information on optional parameters, see Optional Parameters in Office Solutions.

The following code example demonstrates how to use the set_Value method.

This version is for a document-level customization.

private void SetValue()
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
    namedRange1.Value = "Smith";

    Microsoft.Office.Tools.Excel.NamedRange namedRange2 =

This version is for an application-level add-in.

Return to top
© 2015 Microsoft