I have already created a macro that allows me to double click a hyperlink and it displays information from another sheet based on the cell that I have clicked on.
Now I would like to automate the hyperlinking process, what I need is a macro that will take a list of names and hyperlink all of those cells to themselves. so far I have a macro that hyperlinks the activated cell but returns a value of 0 but is hyperlinked ( first set of code)
I will include the macro that I recorded from manually adding the macro as well
Sub HyperLinkME()
frmla = "=HYPERLINK(" + Chr(34) + "#'" + ActiveSheet.name + "'!" +ActiveCell.Address + Chr(34) + "," + ActiveCell.Address + ")"
ActiveCell.Formula = frmla
End Sub
The macro that I recorded is as follows:
Sub ManualHyperlink()
'
' ManualHyperlink Macro
'
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Schedule!A3", TextToDisplay:="dale"
End Sub
Thank you in advance for any and all help!