advanced filter

[bdh2004]

I am starting with a range of say, a2 to f100, on spreadsheet A. I ru
a filter that reduces the range to a5..f10. Later filters of the rang
will highlight other areas of the range, such as a10..f20.

I would like to pull whatever the filtered result is from spreadsheet
to spreadsheet B. The size of the filtered output varies from run t
run. I would appreciate any ideas

 

[J.E. McGimpsey]

One way:

With Range("A2:F100")
.AdvancedFilter <your arguments here>
.SpecialCells(xlCellTypeVisible).Copy Sheets("B").Range("A1")
End With