Monday 12 November 2018

VBA Add Anchor (Hyperlink) to Active Sheet

Sub CreateHLFromActiveSheetToSheet1()
Set Rng = ActiveSheet.Range("A50").End(xlUp).Offset(1, 0)
ActiveSheet.Hyperlinks.Add anchor:=Rng, Address:="", SubAddress:=Sheets("Sheet1").Name & "!A1", _
ScreenTip:="Click to go to Sheet1", TextToDisplay:="Go To Sheet1"


End Sub

Sub CreateHLFromSheet1ToActiveSheet()
Set WS = Sheet1
Set Rng = WS.Range("A50").End(xlUp).Offset(1, 0)
WS.Hyperlinks.Add anchor:=Rng, Address:="", SubAddress:=ActiveSheet.Name & "!A1", _
ScreenTip:="Click to go to Sheet1", TextToDisplay:="Go To " & ActiveSheet.Name

End Sub

No comments:

Post a Comment

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...