Excel VBA data row not filtering

[Simone Fick]

Good day,

I am trying to open a specified workbook, search for a "text"/term and set it as a range (That will be the headers for the tables). Then I clear auto filter and search for a specific column heading that needs to be filtered (I will add more columns to search for and filter).

Problem is that it is not filtering the header and I don;t know what the problem is, I'm not getting any errors. Below is the code. Section in red that is not working.

Please Login or Register  to view this content.

[kev_]

You created variable FilterField as a range
.. So VBA is expecting:
Set FilterField As....

But your VBA does not use Set when attributing the value:
FilterField = WorksheetFunction...

And Field:= is looking for a number ???


Perhaps

Please Login or Register  to view this content.

What will the match function return?

Or possibly???

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

[Simone Fick]

Hi Kev,

Thanks for the reply. I manage to get it working without using "SET" with the below code:

Please Login or Register  to view this content.

Thanks for the help though.