Execute string

Alexey Zalivin · Dec 13, 2003

Hello,

Please advise me how I can receive in cell the result of the string in
other cell, for example:

A1 A2
5*2 10

Thank you and best regards,
Alexey.

J.E. McGimpsey · Dec 13, 2003

One way, using a UDF:

Public Function Eval(rCell As Range) As Variant
Eval = Evaluate(rCell.Text)
End Function

A2: =Eval(A1)

If you're unfamiliar with UDFs, see David McRitchie's page:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Execute string

Alexey Zalivin

J.E. McGimpsey