The routine below nicely renames tab names from user input in ranges brand1, brand2, etc. I need it modified to also accept deleted cells or space in the range (ie if the user does not need a tab, or need the input area for all 10 brand names). Unsure if the tabs should be deleted and re added, or somehow made blank until a name is entered in the range. Clearly tab names cannot be identical , hence my question on adding/ deleting tabs dynamically .
thanks !!
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("brand1,brand2,brand3,brand4,brand5,brand6,brand7,brand8,brand9,brand10")) Is Nothing Then
Worksheets(Cells(Target.Row, "G")).Name = Target.Text
End If
End Sub
Bookmarks