Hyperlinks Collection Object
Description
Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.
Using the Hyperlinks Collection
Use the Hyperlinks property to return the Hyperlinks collection. The following example checks the hyperlinks on worksheet one for a link that contains the word "Microsoft."
For Each h in Worksheets(1).Hyperlinks
If Instr(h.Name, "Microsoft") <> 0 Then h.Follow
Next
Use the Add method to create a hyperlink and add it to the Hyperlinks collection. The following example creates a new hyperlink for cell E5.
With Worksheets(1)
.Hyperlinks.Add .Range("E5"), "http://www.gohere.com"
End With
Properties
Application property, Count property, Creator property, Item property (Hyperlinks collection), Parent property.
Methods
Add method (Hyperlinks collection), Delete method.