Add prefix to re-name sheet

[Mayweed]

This code works fine for naming a new sheet with todays date and increment but does anyone know how to prefix it with something?
For example: instead of "01-31-11-(1)" it would re-name to "Sail-01-31-11-(1)" then "Sail-01-31-11-(2)" and so on.

Please Login or Register  to view this content.

[jaslake]

Hi Mayweed

You could try

Please Login or Register  to view this content.

Not tested.

[Mayweed]

John,
Thanks for your reply, I've already tried that solution but it only works one time: run the macro twice and it throws an error.
The attached sheet shows macro1 working fine with multiple hits and macro2 failing after only one.
Any ideas?

[royUK]

I'm not clear what you want.

Basically your code currently loops through each sheet & checks the name, increasing x if any sheets match the criteria.

It then selects Boat & copies it whilst renaming it with Sail and x added.

When a macro ends the variables are removed from memory, so next time that you run it then it start with x as zero

[royUK]

I think this might be what you want

Please Login or Register  to view this content.

[Mayweed]

I'm trying to copy the boat sheet and then rename it with today's date, any further copies would be incremented by 1. This seems to be working fine with macro1 but I cant figure out how to prefix the new sheet name with anything.
In short... Run macro1 a few times and the resulting sheets should be named Sail-01-31-11 (1), Sail-01-31-11 (2), and so on.

[royUK]

Try the example code

[Mayweed]

That's exactly what I wanted it to do, thanks Roy.