Excel: Autofilter issue when there is space in between two words

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.

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of May 03, 2015.

For more resources for Microsoft Excel