Hello, I have the code below to copy sheet1 and move it to the end renaming it and that part works well, however I get an error message (1004 That name is already taken. Try a different one) if I try and create another copy. What could be added to the code below to check if the name/date exists and if it does just add a number at the end like 2 then 3 and so on.
Please Login or Register to view this content.
Bookmarks