Hyperlink.SubAddress Property (Excel)
Returns or sets the location within the document associated with the hyperlink. Read/write String.
Syntax
expression .SubAddress
expression A variable that represents a Hyperlink object.
Example
This example topic adds a range location to the hyperlink for shape one.
Worksheets(1).Shapes(1).Hyperlink.SubAddress = "A1:B10"