Quote Originally Posted by snb View Post
@Rick

I didn't add any named ranges to the workbook. The VBA code produces those automatically.
I wasn't aware that Advanced Filter did that... good to know. Thanks... obviously I don't use Advanced Filter very offer (like hardly at all), but given the speeds I am seeing for it, I think maybe I will from now on.


Quote Originally Posted by snb View Post
I don't think it's of any use to clean those ranges, they will be overwritten automatically by the next advanced filter operation.
If you had any tendencies toward being obsessive-compulsive, you would.