Range.Name Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns or sets the name of the object.

public:
 property System::Object ^ Name { System::Object ^ get(); void set(System::Object ^ value); };

public object Name { get; set; }

Public Property Name As Object

Property Value

Object

Remarks

The name of a Range object is a Name object. For every other type of object, the name is a String.

The following table shows example values of the Name property and related properties given an OLAP data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".

Caption	Paris	Paris
Name	[Europe].[France].[Paris] (read-only)	Paris
SourceName	[Europe].[France].[Paris] (read-only)	(Same as SQL property value, read-only)
Value	[Europe].[France].[Paris] (read-only)	Paris

When specifying an index into the PivotItems collection, you can use the syntax shown in the following table.

expression.PivotItems("[Europe].[France].[Paris]")

expression.PivotItems("Paris")

When using the Item(Object) property to reference a specific member of a collection, you can use the text index name as shown in the following table.

[Europe].[France].[Paris]

Paris

Applies to