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