String to formula

[joyrock37]

Hi friends,

I have the following task:

Cell A1 contains the string "4,4*EXP(0,03*".
Cell B1 contains a numeric value which can be changed.
Cell C1 concatenates the two strings: = A1&B1&")" to string that Looks like a formula.

In Cell D1, I would like to get the result of the string in Cell C1.

I prefer a standard Excel-function of some sort, but haven't been able to find anything that worked for me.

So I tried:
Function Eval(Ref As String)
Application.Volatile
Eval = Evaluate(Ref)
End Function

But the function Returns #Value !

Big Thanks for your help and suggestions!

 

[joyrock37]

Hi FormR,

it actually worked now also with your first suggestion, I just had to use the german Version of "Substitute"....
Kudos to you - Great help!