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
|