Hyperlink.Range Property

  • Article
Excel Developer Reference

Returns a Range object that represents the range the specified hyperlink is attached to.

Syntax

expression.Range

expression   A variable that represents a Hyperlink object.

Example

The following example stores in a variable the address for the AutoFilter applied to the Crew worksheet.

Visual Basic for Applications 
  rAddress = Worksheets("Crew").AutoFilter.Range.Address

This example scrolls through the workbook window until the hyperlink range is in the upper-left corner of the active window.

Visual Basic for Applications 
  Workbooks(1).Activate
Set hr = ActiveSheet.Hyperlinks(1).Range
ActiveWindow.ScrollRow = hr.Row
ActiveWindow.ScrollColumn = hr.Column

See Also