SubAddress Property

Applies To

Hyperlink object.

Description

Returns a named location in the destination of the specified hyperlink. Read-only String.

Note The named location can be a bookmark in a Microsoft Word document, a named cell or cell reference in a Microsoft Excel worksheet, a named object in a Microsoft Access database, or a slide number in a Microsoft PowerPoint presentation.

See Also

Address property.

Example

This example displays the subaddress of the selected hyperlink.

If Selection.Range.Hyperlinks.Count >= 1 Then
    MsgBox Selection.Range.Hyperlinks(1).SubAddress
End If

This example adds a hyperlink to the selection in the active document, sets the hyperlink destination and subaddress, and then displays them in a message box.

Set SCut = ActiveDocument.Hyperlinks.Add(Anchor:= Selection.Range, _
    Address:="C:\My Documents\Other.doc", SubAddress:= "temp")
MsgBox "The hyperlink goes to " & SCut.SubAddress