advanced filter

  • Thread starter Thread starter bdh2004
  • Start date Start date
B

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
 
One way:

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