The meaning of the Value property depends on the object to which it is applied, as shown in the following table.
Object | Value |
---|---|
Application | Always returns "Microsoft Excel". Read-only. |
Borders | Synonym for Borders.LineStyle . |
Name | A string containing the formula that the name is defined to refer to. The string is in A1-style notation in the language of the macro, and it begins with an equal sign. Read-only. |
Parameter | The parameter value. For more information, see the Parameter object. |
PivotField | The name of the specified field in the PivotTable report. |
PivotItem | The name of the specified item in the PivotTable field. |
PivotTable | The name of the PivotTable report. |
Range | The value of the specified cell. If the cell is empty, Value returns the value Empty (use the IsEmpty function to test for this case). If the Range object contains more than one cell, returns an array of values (use the IsArray function to test for this case). |
Style | The name of the specified style. |
Validation | True if all the validation criteria are met (that is, if the range contains valid data). |
The following table shows example values of the Value 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 following text index names.
Name (OLAP data source) | Name (non-OLAP data source) |
---|---|
[Europe].[France].[Paris] | Paris |