Value Property
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