Share via


Value Property

Value property as it applies to the ChSegmentBoundary object.

Returns or sets a Double that represents the value of the specified segment boundary. Read/write.

expression.Value

*expression   * Required. An expression that returns a ChSegmentBoundary object.

Value property as it applies to the Name and Spreadsheet objects.

Returns a String that represents the name of the specified object. Read-only.

expression.Value

*expression   * Required. An expression that returns one of the above objects.

Value property as it applies to the Borders, ByRef, ParameterValue, and PivotDetailCell objects.

Returns or sets a Variant that represents the value of the specified object. Read/write.

expression.Value

*expression   * Required. An expression that returns one of the above objects.

Value property as it applies to the Range object.

Returns or sets a Variant that represents the value of the specified cell. Read/write.

expression.Value(RangeValueDataType)

*expression   * Required. An expression that returns a Range object

RangeValueDataType   Optional Variant. The range value data type.

Remarks

If the specified range contains more than one cell, this property returns the value of the active cell in the range.

Value property as it applies to the PivotAggregate, PivotAxisMember, PivotColumnMember, PivotMember, PivotPageMember, PivotResultMemberProperty, PivotRowMember, and SchemaProperty objects.

Returns a Variant that represents the value of the specified object. Read-only.

expression.Value

*expression   * Required. An expression that returns one of the above objects.

Example

This example creates a merged cell from the specified range and then places a value in the merged cell.

Sub MergeCells()

   Spreadsheet1.Range("A1:C3").Merge

   Spreadsheet1.Range("A1").Value = "Monday"

End Sub

Applies to | Borders Collection Object | ByRef Object | ChSegmentBoundary Object | Name Object | ParameterValue Object | PivotAggregate Object | PivotAxisMember Object | PivotColumnMember Object | PivotDetailCell Object | PivotMember Object | PivotPageMember Object | PivotResultMemberProperty Object | PivotRowMember Object | Range Object | SchemaProperty Object | Spreadsheet Object

See Also | Formula Property