Share via

Subaddress Property

  • Article

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.SubAddress

*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

Applies to | Hyperlink Object | PivotHyperlink Object

See Also | Address Property | Follow Method