Tash Point O
New Member
- Joined
- Feb 12, 2018
- Messages
- 47
Hello All,
I've been racking my brains trying to shorten a recorded autofilter macro. I recorded the macro 3x's because I have 3 words I need it to find, then it clears entire rows when it finds that word.
I want to make it more compact and put all 3 criteria(words) into 1 and not have 3 different subroutines. I've tried it all, including using Operator:= xlAnd, and then trying xlOr. Nothing is working
Note that the recorded macro uses wildcard, not sure why. I don't need that.
The words are ACM, EM, PAL
Here is what the Data Set looks like:
I've been racking my brains trying to shorten a recorded autofilter macro. I recorded the macro 3x's because I have 3 words I need it to find, then it clears entire rows when it finds that word.
I want to make it more compact and put all 3 criteria(words) into 1 and not have 3 different subroutines. I've tried it all, including using Operator:= xlAnd, and then trying xlOr. Nothing is working
Note that the recorded macro uses wildcard, not sure why. I don't need that.

The words are ACM, EM, PAL
Here is what the Data Set looks like:
