#N/B error processing

[Hans810]

Dear all,

I have the following problem:
In a VBA Excel programme, I am checking the value of an array of cells. In some cells are numerical values. That is okay. But sometimes I have #N/B as value in the cell (the worksheet is delivered to me by a supplier) and then the VBA programme comes to a halt. How can I eliminate the #N/B, or better neglect the error message and continue with my programme?

Thx in advance

 

[Jon von der Heyden]

Hello Hans

Do you mean #N/A error (or is it different in the Netherlands)?

Can you share your code with us? If you are looping thru a range then you could always use On Error Resume Next before the loop, but it may be better to handle the errors differently / directly.

 

[Hans810]

Hi Jon,

Thx for your quick respons.
Indeed in Dutch it shows like #N/B.

br hans

 

[Jon von der Heyden]

Ok

Here is an example of how you would loop thru a range and have it execute only where the cell does not house an error:

<font face=Courier New><SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> c <SPAN style="color:#00007F">In</SPAN> MyRange<br>    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Not</SPAN> IsError(c) <SPAN style="color:#00007F">Then</SPAN><br>        MsgBox "do something"<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">Next</SPAN> c</FONT>

Hope this helps.

 

[Hans810]

Hi Jon,

THX

BR hans