Hello, All.

I am working with AdvancedFilter to pull a list of unique values from a Table (ListObject) in excel. The table column in question has many blank cells in it by design.

When I use the code 
filterRange = range("Categories[Non-Core Comp. Map]").AdvancedFilter(xlFilterCopy, , range("B1"), True)
on that column I get nothing back.

If I fill all the blank cells with N/A for example (which I dont really want to do) I get back what I would expect to see.

Does AdvancedFilter have an aversion to blank cells? None of the MS documentation i read on the method indicated that it does.

Thank you.