ISERROR Formula

  • Thread starter Thread starter Toyin
  • Start date Start date
T

Toyin

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.
 
Hi
one [ bracket too much. Try:
Range("csv1").FormulaR1C1 =
"=IF(ISERROR(DATEVALUE(RC[19])),RC[19],DATEVALUE(RC[19]))"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA formula question 8
Problem with line of code / syntax 4
Code stops after column "L" 1
Why are the two codes below not getting the right formula for myworksheet event change formula? 2
Change worksheet formulas from button on chart sheet 1
Use a Variable in a formula 4
R1C1 Formula 2
Code with formula interfering in worksheet change event 2

Back
Top