Hi,
I'm trying create a copy of the active sheet and name it based on a cell value ("H1" is text January) using a command button.
This works fine. But the problem i run into is that when the name already exist I get an error 1004. Then it creates a copy of the sheet name like "test (2)".
What...