Filter macro not working with more values

[joyinho]

Hi,

I have been stuck with this problem for quite some time now and with the solutions I have found and adapted I have had no luck.

Intention:

"- In an AutoFilter select all values EXCEPT 58 of values (text) which I define

1st attempt:

- Have the macro create a new column and assign a number 0 to all rows I define and 1 to all values not in my list

Please Login or Register  to view this content.

2nd attempt:

- Adapt the macro formula to include all 58 values:

Please Login or Register  to view this content.

When i try to paste in the values something goes wrong and I cannot get it to delete these quotation marks:

Please Login or Register  to view this content.

Where what I want it to do is:

Please Login or Register  to view this content.

Any help would be very much appreciated and would save me a lot of frustration.

[Leith Ross]

Hello joyinho,

You seem much more comfortable using formula solutions. Why do you want to use VBA?

[joyinho]

Indeed I am more comfortable using formulas, however I am slowly learning how to use VBA to expand my skillset and create better solutions.