Skip to main content

Hyperlinks object

Table of contents
  1. Remarks
  2. Example

Represents the collection of hyperlinks for a worksheet or range.


Each hyperlink is represented by a Hyperlink object.


Use the Hyperlinks property of the Worksheet object 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

Use the Add method to create a hyperlink and add it to the Hyperlinks collection. The following example creates a new hyperlink for cell A1.

With Worksheets(1)
    .Hyperlinks.Add .Range("A1"), ""
End With

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>