Hyperlinks Property

Microsoft Excel Visual Basic

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

For more information about returning an object from a collection, see Returning an Object from a Collection.

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