Re: $$Excel-Macros$$ Tricky tricks - 1

[De Premor]

Just figure it out after someone asking it again in another groups

Using Indirect in Defined Name to make it dynamic Row, but just work for 
Column A :-D


=EVALUATE(INDIRECT("A" & ROW()))


On 30-07-2013 14:01, xlstime wrote:

if we have more then thousands of records than?

.

Enjoy
Team XLS



On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot > wrote:


Put "=" sign in cell A2 itself at the bagining of the text... :P


On Sun, Jul 28, 2013 at 1:46 PM, De Premor mailto:d...@premor.net>> wrote:

create defined name inexample : "*Eval**A2*" that referring to
=EVALUATE(A2)

Then in some cell in that sheet, just type *=EvalA2**
*


Pada 28/07/2013 14:59, xlstime menulis:

and what about formula

.

Enjoy
Team XLS



On Sun, Jul 28, 2013 at 11:10 AM, De Premor mailto:d...@premor.net>> wrote:

using udf
On Cell A3, type*=Eval(A2)*

then, on VBE, add module and paste this code
*Function eval(str As String)**
**eval = Evaluate(str)**
**End Function**
*:-X

On 28/07/2013 12:09, xlstime wrote:

Hi All,

How to Evaluate cell value.

let assume that, in cell A2 -  '1+2+3+4'

now how to sum or calculate cell value

hint: evaluate

.

Enjoy
Team XLS

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.

NOTE : Don't ever post confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to
the Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to
excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to
excel-macros@googlegroups.com
.
Visit this group at
http://groups.google.com/group/excel-macros.
For more options, visit
https://groups.google.com/groups/opt_out.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.

NOTE : Don't ever post confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to
the Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to
excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to
excel-macros@googlegroups.com
.
Visit this group at
http://groups.google.com/group/excel-macros.
For more options, visit
https://groups.google.com/groups/opt_out.



-- 
 

Re: $$Excel-Macros$$ Tricky tricks - 1

[ravinder negi]

Function eval(str As String)
    word = Split(str, "+")
    For Each wrd In word
    add_1 = WorksheetFunction.Sum(WorksheetFunction.Substitute(wrd, "'", ""))
    add2 = add2 + add_1
    Next
    eval = add2
    
End Function




 From: xlstime 
To: excel-macros@googlegroups.com 
Sent: Sunday, July 28, 2013 1:29 PM
Subject: Re: $$Excel-Macros$$ Tricky tricks - 1
 


and what about formula



.

Enjoy
Team XLS




On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:

using udf
>On Cell A3, type=Eval(A2)
>
>then, on VBE, add module and paste this code
>Function eval(str As String)
>    eval = Evaluate(str)
>End Function
>:-X 
>
>
>
>On 28/07/2013 12:09, xlstime wrote:
>
>Hi All,
>>
>>
>>How to Evaluate cell value.
>>
>>
>>let assume that, in cell A2 -  '1+2+3+4'
>>
>>
>>now how to sum or calculate cell value
>>
>>
>>hint: evaluate
>>
>>
>>.
>>
>>Enjoy
>>Team XLS
>>
>>
-- 
>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
  be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
  forum @ https://www.facebook.com/discussexcel
>> 
>>FORUM RULES
>> 
>>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) Jobs posting is not allowed.
>>6) Sharing copyrighted material and their links is not allowed.
>> 
>>NOTE : Don't ever post confidential data in a workbook. Forum
  owners and members are not responsible for any loss.
>>--- 
>>You received this message because you are subscribed to the Google
  Groups "MS EXCEL AND VBA MACROS" group.
>>To unsubscribe from this group and stop receiving emails from it,
  send an email to excel-macros+unsubscr...@googlegroups.com.
>>To post to this group, send email to excel-macros@googlegroups.com.
>>Visit this group at http://groups.google.com/group/excel-macros.
>>For more options, visit https://groups.google.com/groups/opt_out.
>> 
>> 
>>
>
> -- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES
> 
>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) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/groups/opt_out.
> 
> 
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To

Re: $$Excel-Macros$$ Tricky tricks - 1

[xlstime]

Good one ..very simple code

.

Enjoy
Team XLS



On Tue, Jul 30, 2013 at 5:43 PM, Prafull Jadhav wrote:

> Sir ,
>
> Can we do this by using Macro
>
> Sub prafull()
>
> For Each x In Range("B2:B10")
> x.Value = "=" & x.Value
> Next
> End Sub
>
> Regards,
> Prafull
>
>
> On Tue, Jul 30, 2013 at 12:31 PM, xlstime  wrote:
>
>> if we have more then thousands of records than?
>>
>> .
>>
>> Enjoy
>> Team XLS
>>
>>
>>
>> On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot wrote:
>>
>>> Put "=" sign in cell A2 itself at the bagining of the text... :P
>>>
>>>
>>> On Sun, Jul 28, 2013 at 1:46 PM, De Premor  wrote:
>>>
  create defined name in example : "*Eval**A2*" that referring to
 =EVALUATE(A2)

 Then in some cell in that sheet, just type *=EvalA2**
 *


 Pada 28/07/2013 14:59, xlstime menulis:

  and what about formula

 .

 Enjoy
 Team XLS



 On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:

>  using udf
> On Cell A3, type* =Eval(A2)*
>
> then, on VBE, add module and paste this code
> *Function eval(str As String)**
> **eval = Evaluate(str)**
> **End Function**
> * :-X
>
> On 28/07/2013 12:09, xlstime wrote:
>
>  Hi All,
>
>  How to Evaluate cell value.
>
>  let assume that, in cell A2 -  '1+2+3+4'
>
>  now how to sum or calculate cell value
>
>  hint: evaluate
>
>  .
>
> Enjoy
> Team XLS
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>--
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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
>

Re: $$Excel-Macros$$ Tricky tricks - 1

[Prafull Jadhav]

Sir ,

Can we do this by using Macro

Sub prafull()

For Each x In Range("B2:B10")
x.Value = "=" & x.Value
Next
End Sub

Regards,
Prafull


On Tue, Jul 30, 2013 at 12:31 PM, xlstime  wrote:

> if we have more then thousands of records than?
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot  wrote:
>
>> Put "=" sign in cell A2 itself at the bagining of the text... :P
>>
>>
>> On Sun, Jul 28, 2013 at 1:46 PM, De Premor  wrote:
>>
>>>  create defined name in example : "*Eval**A2*" that referring to
>>> =EVALUATE(A2)
>>>
>>> Then in some cell in that sheet, just type *=EvalA2**
>>> *
>>>
>>>
>>> Pada 28/07/2013 14:59, xlstime menulis:
>>>
>>>  and what about formula
>>>
>>> .
>>>
>>> Enjoy
>>> Team XLS
>>>
>>>
>>>
>>> On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:
>>>
  using udf
 On Cell A3, type* =Eval(A2)*

 then, on VBE, add module and paste this code
 *Function eval(str As String)**
 **eval = Evaluate(str)**
 **End Function**
 * :-X

 On 28/07/2013 12:09, xlstime wrote:

  Hi All,

  How to Evaluate cell value.

  let assume that, in cell A2 -  '1+2+3+4'

  now how to sum or calculate cell value

  hint: evaluate

  .

 Enjoy
 Team XLS

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




--
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for 

Re: $$Excel-Macros$$ Tricky tricks - 1

[xlstime]

if we have more then thousands of records than?

.

Enjoy
Team XLS



On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot  wrote:

> Put "=" sign in cell A2 itself at the bagining of the text... :P
>
>
> On Sun, Jul 28, 2013 at 1:46 PM, De Premor  wrote:
>
>>  create defined name in example : "*Eval**A2*" that referring to
>> =EVALUATE(A2)
>>
>> Then in some cell in that sheet, just type *=EvalA2**
>> *
>>
>>
>> Pada 28/07/2013 14:59, xlstime menulis:
>>
>>  and what about formula
>>
>> .
>>
>> Enjoy
>> Team XLS
>>
>>
>>
>> On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:
>>
>>>  using udf
>>> On Cell A3, type* =Eval(A2)*
>>>
>>> then, on VBE, add module and paste this code
>>> *Function eval(str As String)**
>>> **eval = Evaluate(str)**
>>> **End Function**
>>> * :-X
>>>
>>> On 28/07/2013 12:09, xlstime wrote:
>>>
>>>  Hi All,
>>>
>>>  How to Evaluate cell value.
>>>
>>>  let assume that, in cell A2 -  '1+2+3+4'
>>>
>>>  now how to sum or calculate cell value
>>>
>>>  hint: evaluate
>>>
>>>  .
>>>
>>> Enjoy
>>> Team XLS
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>>
>>>--
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Vis

Re: $$Excel-Macros$$ Tricky tricks - 1

[Secret Shot]

Put "=" sign in cell A2 itself at the bagining of the text... :P


On Sun, Jul 28, 2013 at 1:46 PM, De Premor  wrote:

>  create defined name in example : "*Eval**A2*" that referring to
> =EVALUATE(A2)
>
> Then in some cell in that sheet, just type *=EvalA2**
> *
>
>
> Pada 28/07/2013 14:59, xlstime menulis:
>
>  and what about formula
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:
>
>>  using udf
>> On Cell A3, type* =Eval(A2)*
>>
>> then, on VBE, add module and paste this code
>> *Function eval(str As String)**
>> **eval = Evaluate(str)**
>> **End Function**
>> * :-X
>>
>> On 28/07/2013 12:09, xlstime wrote:
>>
>>  Hi All,
>>
>>  How to Evaluate cell value.
>>
>>  let assume that, in cell A2 -  '1+2+3+4'
>>
>>  now how to sum or calculate cell value
>>
>>  hint: evaluate
>>
>>  .
>>
>> Enjoy
>> Team XLS
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>>
>>--
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>

Re: $$Excel-Macros$$ Tricky tricks - 1

[De Premor]

create defined name inexample : "*Eval**A2*" that referring to =EVALUATE(A2)

Then in some cell in that sheet, just type *=EvalA2**
*


Pada 28/07/2013 14:59, xlstime menulis:

and what about formula

.

Enjoy
Team XLS



On Sun, Jul 28, 2013 at 11:10 AM, De Premor > wrote:


using udf
On Cell A3, type*=Eval(A2)*

then, on VBE, add module and paste this code
*Function eval(str As String)**
**eval = Evaluate(str)**
**End Function**
*:-X

On 28/07/2013 12:09, xlstime wrote:

Hi All,

How to Evaluate cell value.

let assume that, in cell A2 -  '1+2+3+4'

now how to sum or calculate cell value

hint: evaluate

.

Enjoy
Team XLS

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of
this forum @ https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the
Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to
excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
forum @ https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official 

Re: $$Excel-Macros$$ Tricky tricks - 1

[xlstime]

and what about formula

.

Enjoy
Team XLS



On Sun, Jul 28, 2013 at 11:10 AM, De Premor  wrote:

>  using udf
> On Cell A3, type* =Eval(A2)*
>
> then, on VBE, add module and paste this code
> *Function eval(str As String)**
> **eval = Evaluate(str)**
> **End Function**
> * :-X
>
> On 28/07/2013 12:09, xlstime wrote:
>
>  Hi All,
>
>  How to Evaluate cell value.
>
>  let assume that, in cell A2 -  '1+2+3+4'
>
>  now how to sum or calculate cell value
>
>  hint: evaluate
>
>  .
>
> Enjoy
> Team XLS
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Tricky tricks - 1

[De Premor]

using udf
On Cell A3, type*=Eval(A2)*

then, on VBE, add module and paste this code
*Function eval(str As String)**
**eval = Evaluate(str)**
**End Function**
*:-X

On 28/07/2013 12:09, xlstime wrote:

Hi All,

How to Evaluate cell value.

let assume that, in cell A2 -  '1+2+3+4'

now how to sum or calculate cell value

hint: evaluate

.

Enjoy
Team XLS

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.