Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Returns all customers that started with the letters A through E
Sub SimpleAndFilter()
    Worksheets("SalesReport").Select
    Range("A1").AutoFilter
    Range("A1").AutoFilter Field:=4, _
        Criteria1:=">=A", _
        Operator:=xlAnd, Criteria2:="<=EZZ"
End Sub