Add suffix to Tab Name if it already exists

[tigerdel]

Hi All

I have the code below which copies a tab and places it at the end and renames it with the current date.

However, if the code identifies that the name already exists it just throws up an error.

What I would like it to do is rename the tab and add a suffix at the end.

Any ideas and help gratefully received

Please Login or Register  to view this content.

UPDATE

By using the code below, it produces the new tab and renames it correctly but still shows the error :The name is already taken, try another"

Please Login or Register  to view this content.

[stnkynts]

Try this:

Please Login or Register  to view this content.

[mikerickson]

You could use this

Please Login or Register  to view this content.