Conditionally deleting rows in excel 2007Solved/Closed

Question

Hello,

I'm hoping someone here might be able to help me with this.  I have a spreadsheet where column A is a project name then columns B, C and D are financial data for the specific project.  What I would like to do is delete the entire row for the project only if columns B, C and D ALL contain Zero's.

I can set up a filter and filter out zero's for 1 specific column, but in many of the rows only 1 or 2 of the 3 columns are zero's so that does not work.

Any help is appreciated, thanks.

D

aquarelle · Answer

Hello,

Try with this macro (I presumed that the first row contained the titles).

Public Sub DELETE_Rows_CellZero_Col_B_C_D()
Dim x As Long
Dim y As Long
x = Range("C65536").End(xlUp).Row

For y = x To 2 Step -1

    If Cells(y, 2).Value = 0 And Cells(y, 3).Value = 0 And Cells(y, 4).Value = 0 Then
    
        Rows(y).Delete
    
    End If

Next y
End Sub

Best regards

Excelguru · Answer

Hello

Just a asuggestion
In a new column add the three columns and filter for 0

Conditionally deleting rows in excel 2007

2 responses

Similar discussions

Subscribe To Our Newsletter!