Thread: Selecting Filter Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Selecting Filter Data
See this example

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Crazyhorse" wrote in message ...
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


Reply With QuoteReply With Quote