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