VBA Worksheet name includes "X" issue

[breezypaper]

I have a macro that adds copies of worksheets.

Please Login or Register  to view this content.

My next macro available renames the worksheets based on cell values. The issue I'm having is that after running the first macro is that the second set of worksheets are named "Configuration (2)", etc. My macro listed below is looking for exactly "Configuration" as the worksheet name. How do I modify this to say "If the worksheet name includes the word "Configuration", rename it as cell...etc."?

Please Login or Register  to view this content.

Thanks

[6StringJazzer]

Welcome to the Forum breezypaper!

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

How do I modify this to say "If the worksheet name includes the word "Configuration", rename it as cell...etc."?

That doesn't work either, since you will have two worksheets the include the word "Configuration" and you can't name them both the same thing. Do you mean "the sheet that includes the word Configuration, but not the original Configuration sheet"?

Please Login or Register  to view this content.