Hyperlink.Range Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .Range

expression A variable that represents a Hyperlink object.

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

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.

Workbooks(1).Activate 
Set hr = ActiveSheet.Hyperlinks(1).Range 
ActiveWindow.ScrollRow = hr.Row 
ActiveWindow.ScrollColumn = hr.Column
Show: