Rename Sheet Tab Code Doesn't Handle Duplicates

Hi.

I have the following code I got from this forum. It renames a sheet based on the contents of cell B5. It works fine but when there is a duplicate name in B5 (I have multiple sheets) it errors.
Is there something I can add that will handle duplicate names, e.g. add (1) after the name if it is a duplicate?

Thanks

Ian

Please Login or Register  to view this content.

Thanks for the quick reply!

Had a look there and couldn't see what I wanted (more likely didn't understand it!)

The code I have works fine but it stops when it hits a duplicate. My workbook has mutiple sheets and each sheet has a persons surname in B5. When it is renaming the sheets it stops if there is someone with the same surname in B5 as you can't have two sheets with the same name.

What I'd like the code to do is add a unique identifier to the surname if it is a duplicate e.g Sheet1=Bloggs, Sheet2 =Bloggs1

Thanks

Ian

Thanks Leith.

Tried that and it renamed the sheets 1 through x without using the contents of B5 on each sheet.

I've tried the following code that I found on another post (I've changed it slightly) and it's working.

Thanks for everyones help.

Ian

Please Login or Register  to view this content.