View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nirmal Singh Nirmal Singh is offline
external usenet poster
 
Posts: 17
Default Deleting AutoFiltered Rows

I am using the following code to filter a list and delete unwanted records.

The list has headers on the top row. These are also getting deleted. How can I do this
without deleting the header row?

Range("A1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="<A000000000", Operator:= rator:=xlAnd
Selection.SpecialCells(xlCellTypeVisible).Delete
Selection.AutoFilter
Range("A1").Select

Nirmal Singh