Hi,
i am new to VBA. Actually i was working on main sheet1 where i want to find the text value from cell A12 to another sheet2 in Cell B1. When i used the dynamic hyperlink formula which was success but it given me runtime error 1004 "That name is already taken. Try Different one.
Formula i used:
=HYPERLINK("#"&CELL("address",INDEX(Sheet2!$B$1:$B$16,MATCH(A1,Sheet2!$A$1:$A$16,0))),"LINK")
.
The reason is that i have used the VBA code to get the sheet1 renamed when particular cell text is changed.
i Used this VBA code in sheet1.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set Target = Range("A6")
If Target = "" Then Exit Sub
Application.ActiveSheet.Name = VBA.Left(Target, 31)
Exit Sub
End Sub
could you please help me to sort this out.
Thanks.
Bookmarks