Excel Macros - How do I get Range of AutoFiltered rows?

Question

OK, so I have set AutoFilter property for the whole of the active worksheet (UsedRange.AutoFilter Field:=1, Criteria1:= [blah blah])

Once the filter is applied, how do I programmatically select the range if rows and columns that are the result of the filter.

I checked UsedRange, but that gives the whole (unfiltered) range. Any ideas?

Answer 1

Got it.

Set rng = Worksheets("Sheet1").Range("A1").CurrentRegion.SpecialCells(xlVisible)

Answer 2

The same does not appear to be true for C#. I have the following:

Excel.Range filteredRange = ((Excel.Worksheet)this.Application.ActiveSheet).get_Range("A1", System.Type.Missing).CurrentRegion.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeVisible, Type.Missing);

filteredRange.Rows.Count always returns 1.

Does anyone know how to get the filtered range? Even better, can someone tell be how to get the selected range in and already filtered range?