Excel.Hyperlinks.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Hyperlinks object (Excel)	vbaxl10.chm533072	vbaxl10.chm533072	Excel.Hyperlinks	de28e0af-7a4c-56c3-5fe5-ac47d1654628	03/30/2019	medium

Hyperlinks object (Excel)

Represents the collection of hyperlinks for a worksheet or range.

Remarks

Each hyperlink is represented by a Hyperlink object.

Example

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 
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"), "https://example.microsoft.com" 
End With

Methods

• Add
• Delete

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]