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
Configuration: Windows 7 Internet Explorer 8.0, Excel 2007
Hello,
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 "Pour trouver une solution à ses problèmes, il faut s'en donner la peine." |
Compare columns in worksheets excel 2007 Conditional formatting in excel to show weekends as red Copy function to another sheet, ms excel 2007 Excel 2007 - how to highlight cell if blank Excel 2007 conditional formatting different from "previous row" Excel 2007 conditional formatting if cell is equal to and another cell is equal to Excel 2007 delete rows not containing Excel conditional formatting "compare cells" 2007 Excel rows color 2007 Excel vba delete rows with blank cells How format rows excel 2007 automatically change colors How to apply a formula to a range of rows in excel 2007 If then condition in excel 2007 Insert spacer rows excel Macros delete rows excel Merge same rows excel 2007 Percent running total in excel 2007 Use excel 2007 macro in other workbooks