Range.Value (Excel)

Returns or sets a Variant value that represents the value of the specified range.

When setting a range of cells with the contents of an XML spreadsheet file, only values of the first sheet in the workbook are used. You cannot set or get a discontiguous range of cells in the XML spreadsheet format. The default member of Range forwards calls without parameters to Value. Thus, someRange = someOtherRange is equivalent to someRange.Value = someOtherRange.Value. For ranges whose first area contains more than one cell, Value returns a Variant containing a 2-dimensional array of the values in the individual cells of the first range. Assigning a 2-dim array to the the Value property will copy the values to the range in one operation. If the target range is larger than the array, the remaining cells will receive an error value. Assigning an array to a multi-area range is not properly supported and should be avoided.

Value (RangeValueDataType)

RangeValueDataType: The range value data type. Can be an XlRangeValueDataType constant.


Worksheets("Sheet1").Range("A1").Value = 3.14159