Error handling with "out of range" error, need it for a simple code

[T12ISC]

Hey,

This simple code is giving me a headache. All I want to do is change any sheet on my workbook named "Sheet#" where # is any number, to "Sheet1". I also want to delete any sheets named Sheet1 beforehand.

When I run the code I can't around the fact that if Sheet1 is out of range. Is there a way to error handle an out of range? I would like it to skip anything that's out of range and not stop the macro.

And another note - is there a syntax I can use to circumvent this whole thing? Like "Sheet*"? The asterisk isn't working for me.

Please Login or Register  to view this content.

Thanks for your help!

Edit - code put in code format. Anybody got an idea though?

[AB33]

Please wrap your code with code tags as per forum's rule 3.