If Sheet Exists Stop Macro from Creating a Copy

**uberathlete** · 03-04-2014, 09:40 PM

Hi everyone. I would really appreciate assistance on this.

I have the following code that is part of a larger code:

Please Login or Register  to view this content.

This copies Sheet1 to the end and renames the copy to "SO".

Is there a way to modify the code so that if someone tries to run the macro again and SO already exists, it just stops and doesn't create another copy of Sheet1?

**ajryan88** · 03-04-2014, 09:47 PM

Hi,

Try this:

Please Login or Register  to view this content.

Note: if you simply want the code to resume as normal if the sheet already exists, then just remove the Else condition.

I hope this helps

If Sheet Exists Stop Macro from Creating a Copy

LinkBack

Thread Tools

Rate This Thread

Display

If Sheet Exists Stop Macro from Creating a Copy

Re: If Sheet Exists Stop Macro from Creating a Copy

Thread Information

Users Browsing this Thread

Similar Threads

Trying to copy master data sheet rows if criteria exists to a new sheet

[SOLVED] Macro to Save file as PDF with Error to stop if name already exists

Macro to copy sheet from closed work book and overwrite if sheet already exists

[SOLVED] Run Macro & Rename Sheet upon creating copy from blank.

[SOLVED] stop my speadsheet from creating an automatic backup copy

Bookmarks

Bookmarks

Posting Permissions