AutoFilter.Range Property (Excel)
Returns a Range object that represents the range to which the specified AutoFilter applies.
Syntax
expression .Range
expression A variable that represents an AutoFilter object.
Example
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