I am trying to write a macro that will rename a sheet to a user provided name and then hyperlink to the to the new name
The hyperlink does not seem to recognize the variable name as a sheet name
here is the relevant part of the code:
TAB_NAME = InputBox("NEW TAB NAME?")
Sheets("TEMPLATE (2)").Select
Range("A1:K1").Select
ActiveCell.FormulaR1C1 = TAB_NAME
Range("A2").Select
Sheets("TEMPLATE (2)").Name = TAB_NAME
Sheets("PROJECT LIST").Select
Range("A5").Select
Selection.Hyperlinks(1).SubAddress = "TAB_NAME!A1"
Bookmarks