View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Juuljus Juuljus is offline
external usenet poster
 
Posts: 31
Default searching rows and coloumns

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".