Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Value Property

Office 2003

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.

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.

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.

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.

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

		


See Also | Formula Property


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.