• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add an additional criteria to code

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:
Back
Top