| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Subtract cell formula from existing cell formula | Excel Programming | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Threaded Mode
