Insert formula by VBA gives #NAME!

[FredGexel]

Hello folks,

I have a problem with formulas that I insert in a worksheet. It appears that there is a #NAME! error that results from that insertion. I checked my formula over and over again, there is no error. And when I go in a cell where a formula was inserted and I press Enter, I see the correct value appearing. Which seem to indicate that there is no error in my formula.

For your info, my version of Excel is French.

Any clue of the cause of that ?

Thanks

 

[aMember]

I had this problem and I believe the way I fixed it was

Application.Volatile


in the procedure that wrote the formula to the cell.