Hi All,
I have a piece of code that adds a hyperlink to a cell:
Cells(rowno1, 7).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=Link & CompanyName & " - " &
ProjectTitle & "\" & TrackTitle & " - " & Publisher & ".xlsm", TextToDisplay:=Publisher
In the above "Publisher" is...