View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Using Concatentate in Formula

=eval() isn't built into excel.

I'm guessing that Toppers has an addin that does this evaluation.

One version of a UDF that does that evaluation:

Option Explicit
Function Eval(myStr As String) As Variant
Eval = Application.Evaluate(myStr)
End Function

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



SteveC wrote:

Sweet. Thanks. Never seen that EVAL function before....


--

Dave Peterson