I have a macro that adds copies of worksheets.
Sub AddAnotherSetofTabs()
'
' AddAnotherSetofTabs Macro
'
'
Sheets("Configuration").Select
Sheets("Configuration").Copy Before:=Sheets(3)
Sheets("Supporting Applications").Select
Sheets("Supporting Applications").Copy Before:=Sheets(4)
End Sub
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."?
Sub myTabName()
Sheets("Configuration").Name = ActiveSheet.Range("P2")
Sheets("Supporting Applications").Name = ActiveSheet.Range("P3")
End Sub
Thanks
Bookmarks