Excel 2007 : Remove every row based on value in column

**dalford** · 05-17-2012, 12:59 PM

I need to remove every row that has a "0" in a specific column. What i have it 16463 products and some of the products have a 0 value for quanity and i need to remove them so that they do not import into my site. So i need a macro i can run that will purge the spreadsheet of all products /rows that have a 0 value in the quantity column.

As i said there are 16,436 rows and AA is the column which has the quantity value. To run something that will go to each row find the AA column and if it has a 0 in it delete the entire row. Thank you for your help

Tony
Website Designer
Team Web USA

**jeffreybrown** · 05-17-2012, 02:28 PM

Try

Please test on a copy of your data first

Sub DelRows2()
    Application.ScreenUpdating = False
    With Sheets("Sheet1").Range("AA1", Range("AA" & Rows.Count).End(xlUp))
        .AutoFilter Field:=1, Criteria1:=0
        .Offset(1).EntireRow.Delete
        .AutoFilter
    End With
    Application.ScreenUpdating = True
End Sub