Alternative message box instead of run time error 1004 box no cells were found

Hello,

New to VB and forums...I am having the same issue as above. How do I get a message box to appear instead of the run time 1004 error. My code is attached to a button to clear all entries on a worksheet and I am not sure where to go from here.

Any help would be appreciated.

Please Login or Register  to view this content.

ap6,

Welcome to the forum. 2 pointers -

1. 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.

2. Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.