I have 2 sheets in a excel file, one of the sheet name is 'Test' and another one is 'Final Data'.
Creating hyperlink from sheet 'Test' to sheet 'Final Data'. My code is as below
But it is not working, showing 'Reference Invalid' error.![]()
Worksheets("Final Data").Activate 'This will change project to project sht = ActiveSheet.Name Worksheets("Test").Activate Cells(x, 2).Select ActiveCell.Hyperlinks.Add ActiveCell, Address:="", SubAddress:=sht & "!A" & y, ScreenTip:=Cells(x, 2).Value Worksheets(sht).Activate Cells(y, 13).Value = "Back" Cells(y, 13).Select ActiveCell.Hyperlinks.Add ActiveCell, Address:="", SubAddress:="Test!B" & x, ScreenTip:="Test"
Suppose my second sheet name is 'FinalData' (without space) it is working fine. I can't send this file to client with a sheet name 'FinalData'.
Anyway to create a hyperlink to a sheet which contains blanks in its name?











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks