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 "-"?
Bookmarks