Insert Method (WorksheetHyperlinkCollection)

Inserts the specified hyperlink in the collection.

Syntax

Visual Basic

'Declaration
 
Public Sub Insert( _
   ByVal index As Integer, _
   ByVal hyperlink As WorksheetHyperlink _
) 

C#

public void Insert( 
   int index,
   WorksheetHyperlink hyperlink
)

Parameters

index

The 0-based index in the collection where the hyperlink should be inserted.

hyperlink

The hyperlink to insert in the collection.

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	index is less than zero or index is greater than Count.
System.ArgumentNullException	Occurs when the hyperlink is null.
System.ArgumentException	Occurs when the hyperlink already belongs to a Worksheet.Hyperlinks collection.
System.ArgumentException	Occurs when the hyperlink has a source cell or region from a different worksheet than the owner of the collection.
System.ArgumentException	Occurs when the hyperlink was created with a string address which cannot be parsed in the cell reference mode of the owning workbook.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, 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