Thanks to put me on the track.
I solved my problem like this : create a module in VBA called eval
with content
Function Eval(E As Range)
Eval = Application.Evaluate(E.Text)
End Function
and I refer to that in E2 result cell =eval(D2)
I was just surpised that a so elementary function doesn't exist in
standard list of function.
best regards
Pierre
|