Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

https://stackoverflow.com/questions/58636753/find-and-delete-row-with-multiple-criteria/58637084#58637084

https://stackoverflow.com/questions/16901436/efficient-way-to-delete-entire-row-if-cell-doesnt-contain

https://trumpexcel.com/vba-autofilter/

With ws
 .AutoFilterMode = False
 With .Range("A1")
  .AutoFilter field:=5, Criteria1:="B***-***" ' 5 = Column E
 End With
 .AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
 .AutoFilterMode = False
End With

Note, you can also delete all BUT Match via :

Criteria1:="<>B***-***" ' <>
  • No labels