Autofilter Vs Colorindex

[Dreamer]

I'm going to use autofilter formula...like the following format...

.UsedRange.AutoFilter Field:=7, Criteria1:="<>"

but how can I do this with colorindex?
It seems .UsedRange.AutoFilter Field:=7, Criteria1:="colorindex=6" doesn't work, how can I modify it?

Thanks

[Ken Puls]

Hi Dreamer,

Try checking out Zack's AutoFilter Column by Color KB Entry.

HTH,

[Bob Phillips]

I'm going to use autofilter formula...like the following format...

.UsedRange.AutoFilter Field:=7, Criteria1:="<>"

but how can I do this with colorindex?
It seems .UsedRange.AutoFilter Field:=7, Criteria1:="colorindex=6" doesn't work, how can I modify it?

Thanks

Ron de Bruin has an add-in that does it all http://www.rondebruin.nl/easyfilter.htm