VBA filter deletes what I want to keep

[dgrissom]

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

[rorya]

You want the opposite of what you put:

Please Login or Register  to view this content.

[dgrissom]

Thank you @rorya. It was right before my eyes.

Have a terrific Tuesday!!

[rorya]

Glad to help.