Matt
As I said it depends on how your macro creates the worksheets.
If your macro uses a "For Next" loop then you can use as a start the sample
code I supplied.
But I suggest you post the macro here so that we can help you further.

Cordially
Pascal



"matthewwookie"
a écrit dans le message de news:
...

Hi

Thanks for that, the sheets are produced by a macro and its only the
ones that are produced that way need to be renamed. all original sheets
in the book should stay as they are.

Any ideas?

Matt


--
matthewwookie
------------------------------------------------------------------------
matthewwookie's Profile:
http://www.excelforum.com/member.php...o&userid=27503
View this thread: http://www.excelforum.com/showthread...hreadid=470722