Selecting Filter Data

[Crazyhorse]

I have data on a tab from 2008 to 2006. We have to keep the data from 2007 to
2006 so I save the workbook first. I filter the data.

Selection.AutoFilter Field:=3, Criteria1:="<=12/31/2007", Operator:=xlAnd
Selection.Offset(1, 1).SpecialCells(xlCellTypeVisible).copy

Now I have all of the data from 12/31/2007 to the last year of data. But it
grabs the headers of the data. How do I just select the filtered data only so
I can delete it.

Thanks in advance

 

[Ron de Bruin]

See this example

http://www.rondebruin.nl/delete.htm#AutoFilter