Worksheet.Hyperlinks Property

Excel Developer Reference

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.”

Visual Basic for Applications
For Each h in Worksheets(1).Hyperlinks If Instr(h.Name, "Microsoft") <> 0 Then h.Follow Next

See Also

• Worksheet Object
• Worksheet Object Members