Home » Questions » Computers [ Ask a new question ]

Macro to open excel hyperlinks

Macro to open excel hyperlinks

I would like to know if anyone can help me do a macro to open a list of hyper links.

Asked by: Guest | Views: 278
Total answers/comments: 1
Guest [Entry]

"Sub FollowLinks()
Dim c As Range

For Each c In Range(Cells(1, 3), Cells(1, 3).End(xlDown))
If c <> vbNullString Then
ThisWorkbook.FollowHyperlink (c.Offset(, 1).Value)
End If
Next
End Sub

Source"