how to resolve error message

[eugz]

Hi All.
I create code that generate copy of a worksheet:

Please Login or Register  to view this content.

It is working. But when I want to create a new sheet on the same date, in this case, the sheet will be created but an error message will pop up. How to resolve this error message?

Thanks

[beyond Excel]

Hello. Summarizing:

> Do you want to have two sheets with the same name?...
Well, that's not possible: there can't be two sheets with the same name.

> Do you want to detect that a sheet with some name already exists and name the new sheet with some variant?...
If so, indicate what such variant would be.

[eugz]

Hi beyond Excel. Thanks for reply.
I know that can't be two sheets with the same name. When try to create new sheet with the same date the code generate new sheet with name, for instance, 10-19-22 (2). I will accept it. But I don't want to get pop up error message.
How to solve that problem?

Thanks

[beyond Excel]

.
Hi. For example:

Please Login or Register  to view this content.

[sintek]

Unless I am missing something...
As you are always copying active sheet the new copied sheet becomes the active sheet...So...this will work continuously numbering accordingly...

Please Login or Register  to view this content.

[beyond Excel]

.
Most likely, sintek, is that OP starts by copying a 'model' sheet and that copy is the one that needs to be renamed because it already exists in the workbook.

[sintek]

Not likely if I see his code in post1...But can only say once a reply is received...

When try to create new sheet with the same date the code generate new sheet with name, for instance, 10-19-22 (2). I will accept it

Code in Post 5 does this...

[beyond Excel]

... Code in Post 5 does this...

Let's see if i get it:

> Select a 'template sheet' and run your macro.
> Reselect the 'template sheet' and run your macro again.

Do you see that it does not do what was requested?

[sintek]

No mention of any sheet selection in first post...As the initial active sheet is just creating a copy so no need to re-select original template anyway as the new active now becomes a copy of original...User gets what they ask for...And once again as per other post...OP is not responding...so no idea of actual application...Lets leave it at that for now...

[eugz]

Hi beyond Excel.
I tried your code. It gives error message:
Run-time error '1004'
Method 'Name' of object '_Worksheet' failed

on code line
ws.Name = IIf(j = 0, mName, mName & " (" & j & ")")

Thanks

[eugz]

Hi sintek. Thanks for reply.
I tried your code. It didn't give me an error. But can you do me a favor to explain detail code line

Please Login or Register  to view this content.

What is what
Thanks

[beyond Excel]

Hi beyond Excel.
I tried your code. It gives error message:

Run-time error '1004'
Method 'Name' of object '_Worksheet' failed

on code line

ws.Name = IIf(j = 0, mName, mName & " (" & j & ")")

Could you upload a small workbook to the Forum to see your implementation of what you suggested?...
I ask because there is no reason for the suggestion to fail.

And another thing: do you always select the same sheet when making the copy?...

And don't forget to make two or more copies to see how the name of your sheet changes.

[sintek]

But can you do me a favor to explain detail code line

It simply evaluates if sheet exists or not...But as per beyond Excel suggestion...

Could you upload a small workbook to the Forum to see your implementation of what you suggested?...

And another thing: do you always select the same sheet when making the copy?...