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

[Visual Basic]
Property SubAddress As String
[C#]
string SubAddress { get; set; }
[C++]
__property String* get_SubAddress();
__property void set_SubAddress(String* );
[JScript]
function get SubAddress() : String
function set SubAddress(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";

[Visual Basic]
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

---