Syntax

expression.Value2

expression A variable that represents a Range object.

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.

Visual Basic for Applications 
Range("a1").Value2 = Range("b1").Value2 + Range("c1").Value2
Return date values as floating point numbers? Set currency with double variable? Set value of a particular cell? Setting cell values from VBA code in Excel Value 2 Property Value2 Value2 Property

See also: