Error check and if the cell is not numeric or empty loop to the next item

I have a loop set up to run a function. I need to be able to do some validation and if a cell is invalid it skips to the next loop. I have numerous error checks to do and should any of them be an error I want to skip to the next loop. I know its easy I just cant picture it

Thanks

This is what I have:

Please Login or Register  to view this content.

What I want to do is ensure these cell are valid if they are run the function on that row, if their not skip to the next row

Hi Josie,

ive tried this but it doesn't work, if a letter is typed there is a miss match, and if a row is empty it doesn't complete the function

I don't fully understand how it works so couldn't try to alter it, if you could an explanation would be helpful

Thanks

Excellent thanks Josie that works

but what is this magic you have used ive never come across error handling like that and I could use it in a load of places.

Regards

Jim

Ah that makes sense I like the use of resize I shall certainly be using that one in the future

Thanks for your help

Ah that makes sense I like the use of resize I shall certainly be using that one in the future

Thanks for your help