by vba code filter and delete rows

[bintaleb]

Hi friends

I am trying to filter rows by value which is available in cell (as a variable) then after result returned I want to delete these rows by vba.

thank you

[seenu_1st]

u can loop rows using For Next loop method, load result row numbers in an array, then u can delete rows using the same loop by array.

[vbonline]

Try Below Code

Change Range According to data.

Sub deleteValue()
    Dim deleteValue As String
    
    deleteValue = "Enter Delete Value"
    Range("A1").Select
      Range(Selection, Selection.End(xlToRight)).Select
    Selection.AutoFilter Field:=1, Criteria1:="DeleteValue"
    Range("A1").Select
    ActiveCell.Offset(1, 0).Select
    Range(Selection, Selection.End(xlDown)).EntireRow.Delete
    Range("A1").Select
    Range("A1").AutoFilter
    
End Sub