Greetings! My VBA macro has executed the following instruction correctly
without any problems about 60 times a month for the last year in order to
remove any blanks from the name of the active sheet:

ActiveSheet.Name = Replace(ActiveSheet.Name, " ", "")

This evening when my macro executed this instruction, I could see that it
failed to remove the one blank from the sheet name, and VBA presented me with
the following error message: "Run-time error '1004': Cannot rename a sheet to
the same name as another sheet, a referenced object library or a work book
referenced by Visual Basic"

Does anyone have any ideas as to what might have caused this? Thanks!

--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick