Forum Discussion
how to filter cells if cells contains specific text vba
Maybe I´m wrong, the problem is that you want to filter any word that contains "PTE." , "LTD.", "PRIVATE", "LIMITED", "LLP".
I was looking online and what I found is that you can only filter for 2 values when using wildcards.
Also, find this one where they explain how to make it work. Attached is an example, hope it works.
https://www.mrexcel.com/board/threads/wild-card-unable-to-use-in-autofilter-array.917998/
Maybe I´m wrong, the problem is that you want to filter any word that contains "PTE." , "LTD.", "PRIVATE", "LIMITED", "LLP".
I was looking online and what I found is that you can only filter for 2 values when using wildcards.
Also, find this one where they explain how to make it work. Attached is an example, hope it works.
https://www.mrexcel.com/board/threads/wild-card-unable-to-use-in-autofilter-array.917998/
- Appreciate the help!
