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
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"
But it is not working, showing 'Reference Invalid' error.
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?
Bookmarks