<div>
Its always the way. Thank you. :)
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
Have the following lines in some code and it seems to be getting caught. What have I done wrong exactly?<br />
<br />
Regards<br />
<br />
LK<br />

<pre><code id="code-8153170">ws.Cells(x, 2).FormulaR1C1 = &quot;=IF(ISERROR(INT(RC[-1]),&quot;&quot;&quot;&quot;,INT(RC[-1]))&quot;
ws.Cells(x, 3).FormulaR1C1 = &quot;=IF(ISERROR(MOD(RC[-2],1),&quot;&quot;&quot;&quot;,MOD(RC[-2],1)&quot;</code></pre>
</div>
</div>


Hello Experts,

Have the following lines in some code and it seems to be getting caught. What have I done wrong exactly?

Regards

LK

R1C1 Formula - ISERROR Issue

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.