VBA delete loop only deletes one line

New Contributor

Hello,

I'm trying to create a macro that deletes all lines in a workbook having specific values, here is my code:

 

 

Sub DeleteRowswithSpecificValue()
 
Dim cell As Range
 
For Each cell In Range("x2:x2000")
    If cell.Value = "defer" Then
        cell.EntireRow.Delete
    End If
Next cell
 
End Sub

 

 

The macro serves only to delete the first row containing the value not every row.  I'll attach the file I want it to work on.

Thanks in advance!

2 Replies

@ALASKANBULLWORM 

 

If you don't necessarily want to do it with VBA, an alternative with a filter could also help.

 

Example in the inserted file.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

@NikolinoDE
Thank you for your reply. I am aware of this option, I am trying to create a large series of these macro functions to transform these data files regularly, more quickly, and for individuals I work with who have less knowledge of excel.