how to check #N/A value in cells?

[ccs1981]

hi all,

good day,

i facing a problem to checking if the value is "#N/A".

Please Login or Register  to view this content.

[dilipandey]

Hi ccs1981,


what is the value of "H" in the code as it is appearing to me as text, would suggest you to post the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[OnErrorGoto0]

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Make the second row of your loop

If IsError(Cells(z_row, "H")) Then

Regards

[buran]

OnErrorGoto0 solution will work just fine. Another possible solutions would be

Please Login or Register  to view this content.

[OnErrorGoto0]

I should add that my answer was specific to the question - i.e. checking for #N/A and not any other error. Richard's is a more robust solution generally.