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.

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.