It just does with code what I described (enters the countif formula and
applies an autofilter). So if the manual method doesn't work, it would be
surprising if this worked.

--
Regards,
Tom Ogilvy

"Guy Brown via OfficeKB.com" wrote in message
...
Thanks for the code Bob, does this refer to Column C - I cannot seem to
get
it to work - do I need to select the range or something?

--
Message posted via http://www.officekb.com