Add Code To Ignore Errors

[swordswinger710]

Hello,

My workbook contains a sheet with code which works very well, unless there is an unexpected entry. Then I get a run-time error '13' type mismatch. I'm wondering if there is a simple way to insert a few lines of code that if an error occurs, it is just ignored and nothing happens. Is there something that simple?

This is the code for the sheet in question:

Please Login or Register  to view this content.

[6StringJazzer]

Where is the unexpected entry, and what line of code causes the error?

A generic answer is to insert the following line of code at the top of the Sub:

Please Login or Register  to view this content.

but this could backfire on you, and I normally don't advise it. It would be better to analyze where errors could occur and isolate those spots. Otherwise you could be ignoring errors other than the ones you want to ignore, wreaking havoc.

[swordswinger710]

This part here seems to hang when a number is incorrectly entered, for example a 2.0. instead of 2.0:

Please Login or Register  to view this content.

[Winon]

Hello swordswinger710,

Your code could also require to disable Events, to add to what 6StringJazzer commented. Maybe we should take it step by step, and first tell us at which line of your code do the Error Message appear?

Regards.

[swordswinger710]

Thank you Winon, I think you missed my last post there. Does that help to narrow it down?

[Winon]

Hi swordswinger710,

This is almost like extracting a bad tooth with a chisel and hammer!

Can you perhaps provide us with a sample Workbook, with all your Code, as it seems that you may have some UDF's in there somewhere as well?

Regards.

[swordswinger710]

Alright, point taken. Take a look at this attachment. I ran into the problem when a value in X or Z doesn't contain a number it can work with, such as '2.0.' for example. See what you think.

[sanram]

Now what do you want? Do you want to throw any error message when the cell does not contain any number, or you want to convert that entry to a number?

[sanram]

If you want to throw a message then use this:

Please Login or Register  to view this content.

If you want to convert that to a valid number then use this: Val(Rx) and Val(Rz) Instead of Rx and Rz in formulas and conditions.

[Winon]

Hi swordswinger710,

With some Excel Formulas, Data Validations, Hidden Helper Columns, and Copy and Paste restrictions, please have your file back. Hope you have access to a Shredding Machine 'cause I don't posses such luxury.

Kind Regards.

[swordswinger710]

Thanks for all your help guys, I really appreciate it.

What I think might serve me best is to come up with a way to skip the code if the right format is not present like I'm already doing here:

Please Login or Register  to view this content.

What would be the cleanest way of specifying that if either the X or the Z column do not contain something like '#.#' then the rest of the macro can be skipped as well?

[swordswinger710]

I've been trying to use something like this to keep things as clean as possible:

Please Login or Register  to view this content.

...but I must not be adding it to my existing code properly, as the code only runs for the first entry in X or Z and then doesn't anymore. How can I fix this?

[sanram]

This is happening because you didn't add this line at the end of code :

Please Login or Register  to view this content.

You have declared

Please Login or Register  to view this content.

at the top which is stopping all events for future. Then you have used

Please Login or Register  to view this content.

in the IF condition which is enabling the events before exiting the sub if the IF condition is true. So you need to add this line again at the end of code.

[swordswinger710]

Is this correct? It doesn't seem to be working either:

Please Login or Register  to view this content.

[sanram]

This should work. May be the events are still disabled in your file. You can close the file and reopen it to enable the events again. Also I have attached the working file here. See this.

[swordswinger710]

Oh I get it now, thank you! This almost works, but it also considers '2.0' an invalid entry as well. Is there a simple way to allow periods followed by a zero?

[sanram]

I made little correction there. Hope that it will work now.

Please Login or Register  to view this content.

[swordswinger710]

That, my friend, does it. Thank you so much!

[sanram]

You are most welcome.