Hyperlinks.Item Property

Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a Hyperlinks object.

Parameters

Name Required/Optional Data Type Description
Index Required Variant The name or index number of the object.

Example

The following example activates hyperlink one on cell E5.

Visual Basic for Applications
  Worksheets(1).Range("E5").Hyperlinks.Item(1).Follow

See Also