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?
Bookmarks