[mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Jan/Thu/2012 11:32
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ what is different between .value and .value2
Dear Chandra,
Thanks for your excellent question
The difference between Value and Value2 is that
1
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ what is different between .value and
.value2
** **
Dear Chandra,
Thanks for your excellent question
The difference between Value and Value2 is that
1) Value2 always uses the same value that Excel uses. It
does
You can refer value to get appropriate result..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Jan/Thu/2012 07:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ what is different between .value and .value2
Dear
Value2 gives faster performance as it doesn't take formats in memory
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Dear all
What is different between .value and .value2 can you explain
with range (a1:a100)
.value= .value2
end with
with range (a1:a100)
.value= .value
end with
or
with range (a1:a100)
.value2= .value2
end with
i do't know how do normally use which is performance best ? [ Fast
Dear Chandra,
Thanks for your excellent question
The difference between Value and Value2 is that
1) Value2 always uses the same value that Excel uses. It
does not truncate decimal places like when you divide 22 by 7 and format
the cell for 2 decimal places, value 2 will give you the maximum