Hi experts,
I have a column with data, which is controlled by autofilter in VBA. As an exampel, some of the rows contains thees data:
Column H:
10
1,3,7,10
'empty
3,7,10
(all in same column - H!)
If I use the following code, all four lines returns (month=1)
With Sheets("Costumers")
.Range("A:ad").AutoFilter Field:=8, Criteria1:=Array("*" & month & "*", "="), Operator:=xlFilterValues
end with
The problem is, that "1" is also in the number "10"
I hope you understand my qustion, 'cause it's a little difficult to explain
Bookmarks