Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Filter a column to one of two customers, joined by the OR operator
Sub SimpleOrFilter()
    Worksheets("SalesReport").Select
    Range("A1").AutoFilter
    Range("A1").AutoFilter Field:=4,Criteria1:="=A", Operator:=xlOr, Criteria2:="=B"
End Sub