ExcelBanter - ISERROR Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ISERROR Formula (https://www.excelbanter.com/excel-programming/316933-iserror-formula.html)

Toyin

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.

Frank Kabel

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.

All times are GMT +1. The time now is 11:12 PM.