| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ISERROR Formula
Does anyone know why the following returns a run-time error?
Range("csv1").FormulaR1C1 = "=IF(ISERROR(DATEVALUE(RC[19])),RC[19],DATEVALUE([RC[19]))" I have tried ISERR Function, but still no joy. This formula definitely works when entered manually. Would be grateful for any words of wisdom. Thanks. Toyin. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ISERROR Formula
Hi
one [ bracket too much. Try: Range("csv1").FormulaR1C1 = "=IF(ISERROR(DATEVALUE(RC[19])),RC[19],DATEVALUE(RC[19]))" "Toyin" wrote: Does anyone know why the following returns a run-time error? Range("csv1").FormulaR1C1 = "=IF(ISERROR(DATEVALUE(RC[19])),RC[19],DATEVALUE([RC[19]))" I have tried ISERR Function, but still no joy. This formula definitely works when entered manually. Would be grateful for any words of wisdom. Thanks. Toyin. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding =if(iserror to formula | Excel Discussion (Misc queries) | |||
| Formula Help - Lookup, if, iserror?? | Excel Discussion (Misc queries) | |||
| Adding ISERROR to formula | Excel Worksheet Functions | |||
| Using iserror in formula | Excel Discussion (Misc queries) | |||
| IsError Formula | Excel Programming | |||
Linear Mode
