SubAddress Property

Microsoft Excel Visual Basic

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

Example

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

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