Hyperlink.SubAddress Property

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets(1).Shapes(1).Hyperlink.SubAddress = "A1:B10"

See Also