Export (0) Print
Expand All

Hyperlinks Object (Excel)

Represents the collection of hyperlinks for a worksheet or range.

Each hyperlink is represented by a Hyperlink object.

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://example.microsoft.com" 
End With
Show:
© 2014 Microsoft