Put a formula in a Cell through VBA
Hi,
I'm trying to put a formula in a cell with my VBA function. The resulting
formula doesn't work, it gives me #NAME? error.
A working formula:
=IF(E7281="<0.005",0.0025,IF(F72810,F7281,E7281))
One put from my VBA function :
=IF(E7292="<0.005",0.0025,IF(F72920,F7292,E7292))
If I simply double-click on the error cell, without editing anything, the
formula works after.
Thanks.
|