I'm having problems with autofilter in Excel VBA. I need to filter a column of cells containing text to display instances of "IT", but not words containing the letters "it" - i.e. I want to filter for cells containing "Commercial, IT" but not "Commercial, Committee".I'm having problems with autofilter in Excel VB