I am trying to use a filter function through VBA, in a change event in a specific column. I am using the activecell address in the filter formula, but everytime I hit enter, I get error 50290. what I am actually trying to do is a dynamic searchable dropdown list, but this error is preventing me...