Subaddress Property

Returns or sets a location (within the document) associated with the hyperlink (the string to the right of the # symbol in the hyperlink address). Read/write String.

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

This example sets the address and subaddress for the specified hyperlink.

Sub SetHyperlink()

   Dim hypHyperlink

   Set hypHyperlink = Spreadsheet1.Range("A12").Hyperlink

   hypHyperlink.Address = "http://example.microsoft.com/ExcelDev/e-tips.htm"

   hypHyperlink.Subaddress = "top"

End Sub