Posted to microsoft.public.excel.programming

Toyin

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding =if(iserror to formula	KC	Excel Discussion (Misc queries)	6	August 27th 09 04:30 PM
Formula Help - Lookup, if, iserror??	Ash	Excel Discussion (Misc queries)	9	November 7th 08 05:08 PM
Adding ISERROR to formula	Pierre	Excel Worksheet Functions	3	October 8th 07 07:08 PM
Using iserror in formula	forest8	Excel Discussion (Misc queries)	1	September 2nd 07 03:51 AM
IsError Formula	Steph[_3_]	Excel Programming	1	May 13th 04 08:21 PM

All times are GMT +1. The time now is 05:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us