0

I am trying to filter a column to show all rows that start with the letters A through I. I have looked at the VBA code and I see that for two criteria it shows:

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=6, Criteria1:= _ "=a*", Operator:=xlOr, Criteria2:="=b*"

How would I tell it to only show letters A THROUGH I?

*I would also not like to use Advanced Filter if at all possible.

Community
  • 1
  • 1
user4223089
  • 19
  • 1
  • 11
  • You'll have to use a workaround. See [here for using a dictionary](http://stackoverflow.com/questions/16602872/set-auto-filtering-multiple-wildcards/34822944#34822944) – tigeravatar Jan 04 '17 at 20:22

1 Answers1

1

If you don't mind using an advanced filter, this should work

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=6, Criteria1:= _
    ">=a", Operator:=xlAnd, Criteria2:="<j"
Tom Sharpe
  • 30,727
  • 5
  • 24
  • 37