Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activecell.value or value2?
I am using office xp with win200 pro.
I am confused with the property bvalue of a activecell. There is a value as well as value2. May I know which is better and what is the difference between both? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activecell.value or value2?
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 doesnt 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activecell.value or value2?
The only difference between Value2 property and the Value property is that
the Value2 property doesn't use the Currency and Date data types. A few less Bytes needed to hold the value in a variable. "Sirin" wrote in message ... I am using office xp with win200 pro. I am confused with the property bvalue of a activecell. There is a value as well as value2. May I know which is better and what is the difference between both? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
Excel NPV initial cost in value1 and first year return in value2? | Excel Worksheet Functions | |||
scatter plots and "label" as ("X" value1, value2) | Charts and Charting in Excel | |||
How to dinamic cell that searches for "value1 & value2" in table. | Excel Discussion (Misc queries) | |||
Activecell value | Excel Programming |