Range.Value2 property (Excel)
Returns or sets the cell value. Read/write Variant.
expression A variable that represents a Range object.
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.
This example uses the Value2 property to add the values of two cells.
Range("a1").Value2 = Range("b1").Value2 + Range("c1").Value2
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.