Check to see if a sheet exists

Hi,

I've looked around and found a few examples of how to solve this, but I don't want a message box to display and don't want a new sheet.

I created a command button that deletes a worksheet and clears a couple of list boxes. If the user clicks on the function a second time, an error pops up. what I'd like to do is to have the code check to see if a work sheet exists, and if not, do nothing (except clear the list boxes). Here is my current code. Any help would be great.

Please Login or Register  to view this content.

Regards,

Michael

michaelbails,


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Removing all the unnecessary selecting, this is how I test for the existence of a worksheet:

Please Login or Register  to view this content.

Originally Posted by JBeaucaire

Removing all the unnecessary selecting, this is how I test for the existence of a worksheet:

Please Login or Register  to view this content.

Thanks for the reply...

The GraphicalResults sheet is a plotted chart (I should have mentioned this in the first place - sorry about that), so the ISREF command is failing. This is the sheet I'm trying to delete. The Patient Data sheet is just for a clearcontents command. The other reply in the thread also didn't work, but I'm very novice at error handling amongst other things with vba.

any other thoughts?

Thanks for the help though.

Mike