jassybun
Member
I also want to add "<>East" to the "<>West" so either condition would take into effect. How can I change the VBA below?
Code:
With Sht2
If .AutoFilterMode Then .AutoFilterMode = False
.Range("A1").AutoFilter 5, 82
.Range("A1").AutoFilter 6, "<>West"
.AutoFilter.Range.Offset(1).EntireRow.Delete
.AutoFilterMode = False
End With
Last edited by a moderator: