Use Contents of a Cell to Create a Hyperlink
 

I want to read the values from cell(s) in my currently selected row(s) and
use those to make a hyperline. For instance, the cell(s) in column T of my
current selection have a lookup formula to another sheet to determine the
range I'll use in my hyperlink. I want to use that value instead of
"InstrBooth_Plenum" in the example below, and place it into column U from
info retrieved from column T of the currently selected row(s).

Sub LinkTest()
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"InstrBooth_Plenum", TextToDisplay:="InstrBooth_Plenum"
End Sub

Use Contents of a Cell to Create a Hyperlink
 

Nevermind. I'm making this too difficult. I just found the excel function
=hypelink().

"TKS_Mark" wrote:

I want to read the values from cell(s) in my currently selected row(s) and
use those to make a hyperline. For instance, the cell(s) in column T of my
current selection have a lookup formula to another sheet to determine the
range I'll use in my hyperlink. I want to use that value instead of
"InstrBooth_Plenum" in the example below, and place it into column U from
info retrieved from column T of the currently selected row(s).

Sub LinkTest()
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"InstrBooth_Plenum", TextToDisplay:="InstrBooth_Plenum"
End Sub