Function Add( _
   ByVal anchor As IRange, _
   ByVal address As String, _
   ByVal subAddress As String, _
   ByVal screenTip As String, _
   ByVal textToDisplay As String _
) As IHyperlink

IHyperlink Add( 
   IRange anchor,
   string address,
   string subAddress,
   string screenTip,
   string textToDisplay
)

Parameters

anchor

Specifies the range which the hyperlink will be attached to.

address

Specifies the address of the hyperlink (such as "http://www.spreadsheetgear.com/").

subAddress

Specifies the sub address of the hyperlink (such as "Sheet1!MyDefinedName").

screenTip

Specifies the screen tip to display when the mouse hovers over the range.

textToDisplay

Specifies the text to display for the hyperlink.

Return Value

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Reference