View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
YouWontSpamThisAdress YouWontSpamThisAdress is offline
external usenet poster
 
Posts: 3
Default 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.