AutoFilter.Range property (Excel)
Returns a Range object that represents the range to which the specified AutoFilter applies.
expression A variable that represents an AutoFilter 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.