View Single Post
  #8   Report Post  
PeDevillers
 
Posts: n/a
Default

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