Value Property

  • Article

Returns 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, this property returns an array of values (use the IsArray function to test for this case). Read/write Variant.

expression.Value(RangeValueDataType)

*expression   * Required. An expression that returns one of the objects in the Applies To list.

RangeValueDataType   Optional Variant.

Example

This example sets the value of cell A1 on the datasheet to 3.14159.

myChart.Application.DataSheet.Range("A1").Value = 3.14159

Applies to | Range Object

See Also | LineStyle Property