I am trying to create a hyperlink on a dynamic range of variables that enables me to create a new worksheet and name that worksheet depending on the name of the hyperlink that i have just created. I have used the following code to create the hyperlink:
Sub CreateLinks()
Dim myRng As Range, Cell As Range
Set myRng = Range("c4", Range("c65536").End(xlUp))
For Each Cell In myRng
Cell.Hyperlinks.Add anchor:=Cell, Address:="", SubAddress:="", _
TextToDisplay:=Cell.Value
Next Cell
End Sub
Sub CreateLinks()
Dim myRng As Range, Cell As Range
Set myRng = Range("c4", Range("c65536").End(xlUp))
For Each Cell In myRng
Cell.Hyperlinks.Add anchor:=Cell, Address:="", SubAddress:="", _
TextToDisplay:=Cell.Value
Next Cell
End Sub