| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba formula error
ActiveCell.FormulaR1C1 = "=IF(Results!R[-1]C[1] <
"""",Results!R[-1]C[1],"""")" this does result in correct formula. "RobcPettit" wrote in message ... hi, im using ActiveCell.FormulaR1C1 = "=IF(Results!R[-1]C[1] <"""",Results!R[-1]C[1],"""")" which should give me =IF(Results! A3<"",Results!A3,"") but instead gives me =IF (Results!'A3'<"",Results!'A3',""). Any ideas how to get rid of those ' . Regards Robert |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
| Formula Error-Error Message | Excel Programming | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
| Formula error with Mac resulting in '#NAME' error | Excel Programming | |||
Hybrid Mode
