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

[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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 Rajan

 

Performance wise which is best solution.

Regards

chandru

 



 

On Thu, Jan 5, 2012 at 6:52 PM, Rajan_Verma 
wrote:

As Noorain said..

Please find the attached File 

 

Function GetValueDiff(rngCell As Range) As String

GetValueDiff = "Value = " & rngCell.Value

GetValueDiff = GetValueDiff + " | Value2 = " & rngCell.Value2

End Function

 

Regards

Rajan.

 

From: excel-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 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 number of
decimal places in doing the calculation.

2) Value2 does not use the date or currency data types. If you enter
01/01/2006 in cell and then retrieve Selection.Value and Selection.Value2
you will get 01/01/2006 and 38718 respectively. 

-- 

Thanks & regards,

Noorain Ansari

 <http://excelmacroworld.blogspot.com/> http://excelmacroworld.blogspot.com/

 <http://noorain-ansari.blogspot.com/> http://noorain-ansari.blogspot.com/

 

On Thu, Jan 5, 2012 at 9:40 AM, chandra sekaran 
wrote:

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
working ] 

 

Regards

chandru 

 

 

-- 
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 quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





-- 
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 quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

 

-- 
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 Probl

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

[chandra sekaran]

Dear Rajan

Performance wise which is best solution.
Regards
chandru




On Thu, Jan 5, 2012 at 6:52 PM, Rajan_Verma wrote:

>  As Noorain said..
>
> Please find the attached File 
>
> ** **
>
> Function GetValueDiff(rngCell As Range) As String
>
> GetValueDiff = "Value = " & rngCell.Value
>
> GetValueDiff = GetValueDiff + " | Value2 = " & rngCell.Value2
>
> End Function
>
> ** **
>
> Regards
>
> Rajan.
>
> ** **
>
> *From:* excel-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 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 number of
> decimal places in doing the calculation.
>
> 2) Value2 does not use the date or currency data types. If you enter
> 01/01/2006 in cell and then retrieve Selection.Value and Selection.Value2
> you will get 01/01/2006 and 38718 respectively.
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> 
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> 
>
> ** **
>
> On Thu, Jan 5, 2012 at 9:40 AM, chandra sekaran 
> wrote:
>
> 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
> working ] 
>
>  
>
> Regards
>
> chandru 
>
>  
>
>  
>
> --
> 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
> 
>
> --
> 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4)

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

[Rajan_Verma]

As Noorain said..

Please find the attached File 

 

Function GetValueDiff(rngCell As Range) As String

GetValueDiff = "Value = " & rngCell.Value

GetValueDiff = GetValueDiff + " | Value2 = " & rngCell.Value2

End Function

 

Regards

Rajan.

 

From: excel-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 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 number of
decimal places in doing the calculation.

2) Value2 does not use the date or currency data types. If you enter
01/01/2006 in cell and then retrieve Selection.Value and Selection.Value2
you will get 01/01/2006 and 38718 respectively. 

-- 

Thanks & regards,

Noorain Ansari

 <http://excelmacroworld.blogspot.com/> http://excelmacroworld.blogspot.com/

 <http://noorain-ansari.blogspot.com/> http://noorain-ansari.blogspot.com/

 

On Thu, Jan 5, 2012 at 9:40 AM, chandra sekaran 
wrote:

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
working ] 

 

Regards

chandru 

 

 

-- 
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 quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





-- 
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 quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Book1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[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 number of
decimal places in doing the calculation.

2) Value2 does not use the date or currency data types. If you enter
01/01/2006 in cell and then retrieve Selection.Value and Selection.Value2
you will get 01/01/2006 and 38718 respectively.

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

On Thu, Jan 5, 2012 at 9:40 AM, chandra sekaran wrote:

> 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
> working ]
>
> Regards
> chandru
>
>
>
> --
> 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 quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
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 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com