Skip to content

Latest commit

 

History

History
41 lines (24 loc) · 969 Bytes

Excel.Range.Value2.md

File metadata and controls

41 lines (24 loc) · 969 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.Value2 property (Excel)
vbaxl10.chm144217
vbaxl10.chm144217
Excel.Range.Value2
0a5d7e6f-2886-5048-66ad-a5078e3465e7
05/11/2019
medium

Range.Value2 property (Excel)

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

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.

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

[!includeSupport and feedback]