runtime error 13 type mismatch

**Justair07** · 06-28-2013, 01:44 PM

Is it possible to bypass this message? One of my cells may have an error message or a "#N/A" and I keep getting this error. Here is my code:

Please Login or Register  to view this content.

**AndyLitch** · 06-28-2013, 01:50 PM

Try this

Please Login or Register  to view this content.

**Justair07** · 06-28-2013, 02:14 PM

Did not work, still getting the error

**Norie** · 06-28-2013, 02:22 PM

If the value in O22 is not numeric then you will get a type mismatch on 2nd part of the expression in the If.

Try separating things.

Please Login or Register  to view this content.

**AndyLitch** · 06-28-2013, 02:22 PM

Have a look in Range O22 and see what is in there.. It may not be the problem

**Justair07** · 06-28-2013, 02:46 PM

Thank you very much, separating worked perfect!

Re: runtime error 13 type mismatch