Value Property

Microsoft Office Web Components Object Model

Show All

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