Conditionally deleting rows in excel 2007
Solved/Closed
Alta
-
Oct 20, 2009 at 01:15 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Jun 20, 2011 at 04:15 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Jun 20, 2011 at 04:15 PM
Related:
- Conditionally deleting rows in excel 2007
- Save as pdf office 2007 - Download - Other
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 21, 2009 at 06:51 AM
Oct 21, 2009 at 06:51 AM
Hello
Just a asuggestion
In a new column add the three columns and filter for 0
Just a asuggestion
In a new column add the three columns and filter for 0
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Oct 20, 2009 at 03:58 PM
Oct 20, 2009 at 03:58 PM
Hello,
Try with this macro (I presumed that the first row contained the titles).
Best regards
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
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Jun 20, 2011 at 04:15 PM
Jun 20, 2011 at 04:15 PM
Hi confused,
Please could you load a brief example of your excel file (without any private or personal data) on https://authentification.site then copy past the created link to your next answer.
Best regards
Please could you load a brief example of your excel file (without any private or personal data) on https://authentification.site then copy past the created link to your next answer.
Best regards