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

Remarks
The only difference between this property and the Value property i
that the Value2 property doesn’t use the Currency and Date data types
You can return values formatted with these data types as floating-poin
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").Value

--
S@
-----------------------------------------------------------------------
S@S's Profile: http://www.excelforum.com/member.php...fo&userid=1606
View this thread: http://www.excelforum.com/showthread.php?threadid=31929