If Worksheet name exists - then...

Please Login or Register  to view this content.

What I am needing to do is essentially create an If there is already a worksheet named "Format(sdate, "yyyy-mm-dd")" in ob2ws, then to delete that sheet and then create a new one with the name

How do I do this without disrupting the rest of the code?

Hi.
You don't need to waste time to find out if the sheet exists: just delete it (it exists or not). I mean:

Please Login or Register  to view this content.

With the above:
- If the sheet exists, it is deleted.
- And if it doesn't exist: Nothing happens!

Originally Posted by beyond Excel

Hi.
You don't need to waste time to find out if the sheet exists: just delete it (it exists or not). I mean:

Please Login or Register  to view this content.

With the above:
- If the sheet exists, it is deleted.
- And if it doesn't exist: Nothing happens!

That is perfect!

thank you.