Re: $$Excel-Macros$$ what is different between .value and .value2

2012-01-05 Thread Kris
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

RE: $$Excel-Macros$$ what is different between .value and .value2

2012-01-05 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ what is different between .value and .value2

2012-01-05 Thread chandra sekaran
[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

RE: $$Excel-Macros$$ what is different between .value and .value2

2012-01-05 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ what is different between .value and .value2

2012-01-04 Thread NOORAIN ANSARI
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