PDA

View Full Version : [SOLVED] Autofilter Vs Colorindex



Dreamer
06-29-2005, 08:31 PM
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
06-29-2005, 09:08 PM
Hi Dreamer,

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

HTH,

Bob Phillips
06-30-2005, 01:22 AM
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