Hello All,
I have come across this strange issue.
I am using vba to autofilter. So one column has all the criteria required to filter. The column I used is W. So W1 is 'John Musk' and W2 is just 'Peter'. I have W1 and W2 as a named range.
Now, I use vba to autofilter with the named range as criteria and have noticed that it just filters 'Peter' and not 'John Musk' even though it has 'John Musk' in the data.
I have come across this strange issue.
I am using vba to autofilter. So one column has all the criteria required to filter. The column I used is W. So W1 is 'John Musk' and W2 is just 'Peter'. I have W1 and W2 as a named range.
Now, I use vba to autofilter with the named range as criteria and have noticed that it just filters 'Peter' and not 'John Musk' even though it has 'John Musk' in the data.