| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If function in Macro
Hi,
This is the if statement in Excel, =IF(NOW()+7H5,$J5,""). This is how I have it in the macro, Range("R5").Select ActiveCell.FormulaR1C1 = "=if(now()+7RC[-10],$RC[-8],"")" But I get and object defined error. Is my problem with R1C1 reference style or something else? Thanks rick When I run the macro I get |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
| macro or function | Excel Programming | |||
| Macro run from if then function | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Run macro from IF function | Excel Programming | |||
Threaded Mode
