NativeExcel2 for .Net Developer's Reference

IHyperlink.SubAddress Property

Returns or sets the location within the document associated with the hyperlink.

[Visual Basic]
PropertySubAddressAsString
[C#]
stringSubAddress{get;set;}
[C++]
__propertyString*get_SubAddress();
__propertyvoidset_SubAddress(String*);
[JScript]
functiongetSubAddress():String
functionsetSubAddress(String);

Example

This example topic changes a range location of the first hyperlink on worksheet one.

[C#]
IHyperlink hlink = book.Worksheets[1].Hyperlinks[1];
hlink.Address = "c:\\documents\\book.xls";
hlink.SubAddress = "B10:D15";
[VisualBasic]
Dim hlink As IHyperlink = book.Worksheets(1).Hyperlinks(1)
hlink.Address = "c:\documents\book.xls"
hlink.SubAddress = "B10:D15"
[C++]
IHyperlink* hlink = book->Worksheets->Item[1]->Hyperlinks->Item[1];
hlink->Address = S"c:\\documents\\book.xls";
hlink->SubAddress = S"B10:D15";

See Also

IHyperlink Interface | NativeExcel Namespace | IWorksheet.Hyperlinks Property | IRange.Hyperlinks Property | IHyperlinks Interface