Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Value2 Property [Excel 2003 VBA Language Reference]

Office 2003

Returns or sets the cell value. Read/write Variant.

Remarks

The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types. You can return values formatted with these data types as floating-point numbers by using the Double data type.

Example

This example uses the Value2 property to add the values of two cells.

Range("a1").Value2 = Range("b1").Value2 + Range("c1").Value2
		


Applies to | Range Collection


Show: