Value Property

Value Property

See Also         Example         Applies To

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