Hyperlink.SubAddress Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns or sets the location within the document associated with the hyperlink. Read/write String.

expression .SubAddress

expression A variable that represents a Hyperlink object.

This example topic adds a range location to the hyperlink for shape one.

Worksheets(1).Shapes(1).Hyperlink.SubAddress = "A1:B10"