Macro to check if sheet name exits

Hi All,

I have this macro, but I like to add if sheet name already exits in workbook then nothing happen or it add a something else at the back. for exp if sheet1 already in the workbook then it add sheet11 or anything.
Thanks in advance for help
RR

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you very much,
Is the other option available if sheets exits then it delete the exiting one and add new one or change the name with adding sonmthing at the back.

adding something at the back is the most challenging of the two options you suggested because you have to recheck to see if the "something at the back" sheet already exists and if so you need 2 "something at the back". Then you have to check the 2 "something at the back" and so on. It is possible to code but takes a bit of time. Quicker to go with your first option which is just to delete the sheet.

Please Login or Register  to view this content.

Thank you very much for your time and help. This will works for me.