G Guest May 4, 2007 #1 How can I type an equation in one cell as a text string eg. "2+3+(5+6)*6" and get its result in the other one?
How can I type an equation in one cell as a text string eg. "2+3+(5+6)*6" and get its result in the other one?
P Pete_UK May 4, 2007 #2 Do a search of the newsgroups looking for Eval - you can define a User- defined Function making use of Evaluate to do this. Hope this helps. Pete
Do a search of the newsgroups looking for Eval - you can define a User- defined Function making use of Evaluate to do this. Hope this helps. Pete
G Guest May 4, 2007 #3 Try this tiny UDF: Function value_of(r As Range) As Variant value_of = Evaluate("=" & r.Value) End Function
Try this tiny UDF: Function value_of(r As Range) As Variant value_of = Evaluate("=" & r.Value) End Function
