automatic clear contents and copy current tab with new name

[Jeffreyxx01]

Hello everyone,

I would like to create a macro that copy my "worker" tab and pop a message box that will change the name of the new tab for example: "worker" >> "XXX"

Also I want the macro to clear the contents of the cells I would allocate for my needs for example:

A1 A2 A3 >>> Those are just example,

Can someone help?

Thanks

 

[Joe4]

Re-posted here: https://www.mrexcel.com/forum/excel-questions/1060267-combined-two-codes-one.html

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.