Is it not possible to specify the range for the advanced filter via a Named Range? I have tried it when the range was a table, and when it was not. In both cases, I did not get an error, but it filtered out everything except the first row, which did not meet the criteria of the filter.