Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of banner Go to start of banner

AutoFilter - Excel VBA

Skip to end of metadata

Created by FreeSoftwareServers, last modified on Nov 15, 2019

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

This site is just a Tech Blog, nothing is guaranteed!