renaming sheets where name reoccurs

I am using a macro to rename a large number of spreedsheets according to the values in a particular couple of cells.

Usually this works very well however recently i have encountered a problem with a bug occuring in the rare event that two sheets have the same cell value and hence the macro tries to give the sheet the same name as a previously named sheet.

Can anyone think of a simple code i can use to, for example, tell excel to add a b onto the end of the sheet name if it has already occured (and then c if it happens to occur twice, then d, etc) whenever this happens?

Perhaps you could do a check on the number of times the value occurs in the list using COUNTIF, and loop through adding a different suffix. What code are you using now?

You could add a simple function to check if a sheet name exists:

Please Login or Register  to view this content.

Then call it in the following manner, where NewSheetName is the name you're trying to add:

Please Login or Register  to view this content.