Checking for a sheet

[toocold]

Good morning,

I was wondering if it is possible to check to see if a sheet exists in a workbook and if it does, delete it. The reason I am asking is that I have something that adds sheets to run various reports and then deletes the sheet once the report has run. The error handling kicks them back to the main menu if something goes wrong.

The problem is that if an error happens while trying to run one of the reports, the next time it tries to run the report it is going to generate an error when it tries to name the new sheet that was added for the report. Any ideas?

For example, I want to test if any of Sheets("Report1"), Sheets("Report2"), Sheets("Report3") exist and if so, delete whichever one.

Thanks,
dw

[Leith Ross]

Hello Toocold,

This macro will delete the worksheet named if it exists.

Please Login or Register  to view this content.

Examaple:
DeleteSheet "Report3"

Sincerely,
Leith Ross

[toocold]

Thanks Leith,

That was exactly what I needed to get things working.