Range.Name Property
Returns or sets the name of the object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Name As Object
Get
Set
'Usage
Dim instance As Range
Dim value As Object
value = instance.Name
instance.Name = value
Object Name { get; set; }
Property Value
Type: System.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".
Property |
Value (OLAP data source) |
Value (non-OLAP data source) |
|---|---|---|
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.
Syntax (OLAP data source) |
Syntax (non-OLAP data source) |
|---|---|
expression.PivotItems("[Europe].[France].[Paris]") |
expression.PivotItems("Paris") |
When using the Item property to reference a specific member of a collection, you can use the text index name as shown in the following table.
Name (OLAP data source) |
Name (non-OLAP data source) |
|---|---|
[Europe].[France].[Paris] |
Paris |