Run Time Error '91' Object Variable or block variable not set

I am writing a code for my job but I have hit a road block. I need to write a macro that checks sheet 1 for a specific number then if that number is not found then it searches three other sheets and if the number is found it deletes it. My problem is that I get an error (Run Time Error '91' Object Variable or block variable not set) when i run the program for a number that is not found on one of the subsequent sheets. Ive been working on this for days and I cant figure it out. Heres the code with the number replaced with stars

Please Login or Register  to view this content.

When posting code please use code brackets. To do this, highlight your code and press the # button in the toolbar.

What error are you getting?

Thanks Solus.

leao67,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Please Login or Register  to view this content.

You don't have a statement for then

Please Login or Register  to view this content.