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
|