Search VBA causing error when data isn't there to find

Hi,

I'm creating some code that basiclly checks to see if a code is there before proceeding with the rest of the script. I can make it find existing codes and tell me that it's there but if I enter one that isn't there it freaks out and goes into debugging.

I need a way of stopping it from chucking a fit when the code doesn't already exist.

My current code is as follow;

Please Login or Register  to view this content.

Hi Leith,

Thanks for the re worked code however this code is causing a strange problem when I call it.

The Sub i'm calling the ChkJobNo from has code in it to check cells to see if there's anything in them and if not it brings up a message box telling you that there should be and then copies info from one sheet to another.

When I call ChkJobNo and the number isn't found which it's searching for it causes the other Sub code to think there are empty cells when there are not.

Why is this happening? The ChkJobNo is called at the top of the other subs code. I'll actually paste the other sub code below for your reference.

Please Login or Register  to view this content.