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
qu
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
[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 y
xcel-macros@googlegroups.com [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 betw
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