Hyperlink.SubAddress (Excel)

Returns or sets the location within the document associated with the hyperlink.

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