Macro for selecting multiple filtered criteria

[Justair07]

Hello,

I'm having an issue running the following macro:

Please Login or Register  to view this content.

But it's only displaying the "TPC FLAT*", not anything else. Is the wildcard(*) causing this issue?

Thank you,

-Justair07

[AB33]

Like Filter Operators of OR and AND, the wild card works with 2 choices(Options) ONLY.

[Justair07]

So is possible to do what I'm attempting in another way?

[AB33]

I do not know what are you trying to do.

The array works with any number of options but if you have a wild card, you may put two wildcards in one line at a time.
You then put in another line with 2 wild cards below.
The concept is similar to filtering by different columns, so you put in each column criteria on a separate line.

[Justair07]

Here is my poor attempt. I'm trying to make it so that only "NPC AWG*", "SPC AWG*", and "TPC AWG*" is filtered to show.

Please Login or Register  to view this content.

Attached is a sample workbook as well.

[AB33]

Hmm!
Your code is correct and my suggestion will not work with selecting the visible cells as the last * line will show visible cells only.

I was think you want to copy or delete visible cells once the first * filter is on, and then remove the filter,redo with the second wild card and copy or delete again.

I have seen people use a helper column to get around, but can not seem to remember the steps.

[Justair07]

Wow!

This is a lot more complicated than I thought it would be. There must be an easier way. I'm obsessed now.