Skip to main content

Worksheet.Hyperlinks property

Table of contents
  1. Syntax
  2. Example

Returns a Hyperlinks collection that represents the hyperlinks for the worksheet.

Syntax

expression.Hyperlinks

expression A variable that represents a Worksheet object.

Example

This example checks to see whether any of the hyperlinks on worksheet one contain the word Microsoft.

For Each h In Worksheets(1).Hyperlinks
    If InStr(h.Name, "Microsoft") <> 0 Then h.Follow
Next

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>