Error 50290 in filter function

[nando88]

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 from achieving my goal. I am using the activecell in the filter formula, but everytime I click the validation list, I get this error and I can't get passed it.

Any help will be greatly appreciated.

Thanks.

 

[Alex Blakenburg]

See if this help, if not perhaps post the code you are using.
VBA Error 50290 encountered in Worksheet-Change macro when changing a data validated cell and the validation "fails"

 

[nando88]

The formula I am trying to use in the data validation is the following:

Range("c2").formula2="=filter(indirect("Table1'),is number(search(" & active cell address & ",indirect("Table1"))))