View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Jim May
 
Posts: n/a
Default How I can calculate the value of string "120+150+120... etc"

Never mind, the sun has come out.. LOL

"Jim May" wrote in message
news:8C7Zf.55132$KE1.54201@dukeread02...
So how is it that I can end up getting #NAME?
Always the "black-cloud-following-me", it seems...


"vezerid" wrote in message
oups.com...
Use this VBA function:

Function eval(s As String)
eval = Application.Evaluate("=" & s)
End Function

Then you can use this in a cell as:

=eval(A1)

To install,
Alt+F11 to go to the VBA editor.
Insert | Module
Paste the above code.
Ready to use

HTH
Kostis Vezerides