0 Members and 1 Guest are viewing this topic.
Sheets("Sheet3").Hyperlinks.Add Sheets("Sheet3").Cells(3, 3), "", Sheets("Sheet1").Name & "!B2", "", "Hello"
Sub Test() Sheets("This is sheet 3").Select Range("C3").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "'Sheet 1'!B2" ActiveCell.FormulaR1C1 = "'Hello"End Sub