The Hyperlinks collection represents the list of hyperlinks in a worksheet or range. Each Hyperlink object represents a single hyperlink in a worksheet or range. The Hyperlinks collection has an Add and Delete method besides the typical collection of properties and methods. The Add method takes the text or graphic that is to be converted into a hyperlink (Anchor) and the URL address or filename (Address), and creates a Hyperlink object. The Delete method deletes the Hyperlinks in the collection.
Was this article helpful?