How to turn a string formula into a "real" formula?

Question

I have `0,4*A1` in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?

Accepted Answer

`Evaluate` might suit:

http://www.mrexcel.com/forum/showthread.php?t=62067

```
Function Eval(Ref As String)
    Application.Volatile
    Eval = Evaluate(Ref)
End Function
```

Solution