Hi Juuljus.

I used the Advanced Filter. It works almost fine.
The table I take the data from has some colors and boarders. I don't
want them. I tried to use ColorIndex:=xlNone, LineStyle:=xlNone
inside the autofilter sentence, but it gave an error. Is there a way?

Post the relevant code.

Plus, I want to get the exact match. I searched for "IS", but the
filter also gave "IS 2" and "IS W".

To get an exact match, enter the criterion as:

="=IS"


---
Regards,
Norman


"Juuljus" wrote in message
oups.com...
Thanks Norman,

I used the Advanced Filter. It works almost fine.
The table I take the data from has some colors and boarders. I don't
want them. I tried to use ColorIndex:=xlNone, LineStyle:=xlNone inside
the autofilter sentence, but it gave an error. Is there a way?
Plus, I want to get the exact match. I searched for "IS", but the
filter also gave "IS 2" and "IS W".