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

I am currently using a macro to copy a sheet from a closed workbook in to my current workbook. However this copying is based on the sheet name. At present when I run the following code

Please Login or Register  to view this content.

It does exactly what I want. However if I specify to run the macro again with the same sheet name to be copied I get an error ""Cannot rename a sheet to the same name as another sheet" however I want to be able to overwrite the sheet with the data. How would I edit the macro code to be able to overwrite?

Thanks for any help

Add some code to delete the sheet it is replacing before it is copied in.

Whomever helped you construct the current macro should be able to adjust it to delete a sheet when needed.

APOLOGIES...for the sarcastic post. I'd forgotten the link in the original post to the code being used.

Good job Trevor. Just right.

Hi munkee,

While it's always tricky to modify someone else's code, try this:

Please Login or Register  to view this content.

HTH

Robert

Thanks JBeaucaire

Thanks for the help trebor but I have found an issue. If there is not a sheet with the same name as newtabname i get an error on this line:

If Len(Sheets(newtabname).Name) > 0 Then

However if there is a sheet with the newtabname already present within the workbook everything over writes and runs perfect. I assume there is something simple missing.

Current code:

Please Login or Register  to view this content.

Hi munkee,

I may have a solution for you but for me to provide it you'll have to ask a moderator to change your thread title to something meaningful and have your code placed (wrapped) in code tags as your thread is currently in violation of forum rules one and three respectively (see here for further details).

Regards,

Robert

Thanks munkee

Let me know how this goes:

Please Login or Register  to view this content.

HTH

Robert