I am trying to have my autofilter keep everthing that is either Greensboro or Randleman and delete everything that is not.
What am I missing?
.AutoFilter Field:=5, Criteria1:= _
"=*RANDLEMAN*", Operator:=xlOr, Criteria2:="=*GREENSBORO*"
If .Columns(5).SpecialCells(xlCellTypeVisible).Count > 1 Then
.Offset(1).Resize(n - 1).EntireRow.Delete
End If
.AutoFilter
Bookmarks