filtering with variables
Posted on 2013-06-26
i have a list box of values which i would like to exclude from the my data
if i add the following code the filter works
Range("A:AA").AutoFilter 14, "<>BGD*", xlAnd, "<>TTS*"
i've created a function to build the underlined text based on the values in the list box but when i use the variable from the function the auto filter does not work. any suggestions why?
Range("A:AA").AutoFilter 14, variable