Delete a filtered set

C

cmac

Hello,

As a part of a macro I would like to turn auto filters on and then find rows
of data that contain a zero in the 4th field. I would then like to delete
the rows contained in the results - however, the range may be different each
time the macro is run. is there a way to delete the results in general - can
you help?
 
M

Michael

Try this in Column A:

Sub FilterZeros()
Columns("A:A").AutoFilter
Range("A:A").AutoFilter Field:=1, Criteria1:="=0", Operator:=xlAnd
Range("A:A").SpecialCells(xlCellTypeVisible).EntireRow.Delete Shift:=xlUp

End SUb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to delete rows for only filtered results 4
Delete all filtered rows from a macro? 1
Macro to Convert Value to Number, Sort, then Delete 16
Copy Paste with fiter and hide copies filtered and hidden 0
Setting a Filtered Range 7
Filter set in macro filters all values out 1
Delete rows using VB 4
Delete Rows Filtered within Auto Filter 1

Top