trying to delete a query

Hey, I was wondering if anyone could help me with a problem. What my excel sheet is doing is importing a bunch of data from a query. I have all my queries linked to buttons through macros. There are going to be 20-30 buttons that are linked to a query, and each query will produce a different amount of data(in this case, account numbers). When pressing a button linked to a query(i also have one 'Clear' button that just deletes the data, thats all), i use a macro to delete the previous query so it can import the new query into the same cell. The problem I am having is that when a button is pushed and there is no query, I am getting an error message. Here is my original code(macro), and the underlined code is where i am getting the error

Please Login or Register  to view this content.

I appreciate any help...and this is my first post so let me know if you need anything else

Hi

Perhaps re-write to:

Please Login or Register  to view this content.