Filtering with a value range and a third value

[jcarlosd]

I have a macro that filters a range with the following criteria:
.AutoFilter Field:=1, Criteria1:=">=1", Operator:=xlAnd, Criteria2:="<=10"

I would like to add another criteria: empty values come with a "-" character. I do not want to change my worksheet and replace "-" by "0".

Is there a way to filter my range for values between 1 and 10, or equal to "-"?

[AB33]

You can only use two creteria with the filter function.

You can use Array, but will only take lists of values, but not comparison.

The other option would be to use two filters, ie first filter using 2 creteria, clear the filer and do again with the last creteria.