'Declaration
 
Public Overloads Function Add( _
   ByVal destinationAddress As String, _
   ByVal topLeftRowId As Integer, _
   ByVal topLeftColumnId As Integer, _
   Optional ByVal hyperlinkRowLength As Integer, _
   Optional ByVal hyperlinkColumnLength As Integer, _
   Optional ByVal textToDisplay As String, _
   Optional ByVal tooltip As String _
) As Hyperlink

'Usage
 
Dim instance As HyperlinkCollection
Dim destinationAddress As String
Dim topLeftRowId As Integer
Dim topLeftColumnId As Integer
Dim hyperlinkRowLength As Integer
Dim hyperlinkColumnLength As Integer
Dim textToDisplay As String
Dim tooltip As String
Dim value As Hyperlink
 
value = instance.Add(destinationAddress, topLeftRowId, topLeftColumnId, hyperlinkRowLength, hyperlinkColumnLength, textToDisplay, tooltip)

public Hyperlink Add( 
   string destinationAddress,
   int topLeftRowId,
   int topLeftColumnId,
   int hyperlinkRowLength,
   int hyperlinkColumnLength,
   string textToDisplay,
   string tooltip
)

Parameters

destinationAddress

The address that corresponds to the Hyperlink's destination.

This can be the Address of a Cell, an external document, a website or an email address.

topLeftRowId

The Id of the Row that corresponds to the start of the Hyperlink's active range.

topLeftColumnId

The Id of the Column that corresponds to the start of the Hyperlink's active range.

hyperlinkRowLength

Specifies on how many vertical Cells the Hyperlink is active.

The default value is 1.

hyperlinkColumnLength

Specifies on how many horizontal Cells the Hyperlink is active.

The default value is 1.

textToDisplay

The Cell’s text, if it is different from the existing one.

The default value is null.

tooltip

The tooltip text that will be displayed on Mouse Over.

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

HyperlinkCollection Class
HyperlinkCollection Members
Overload List