Is it possible to fliter colums with cells that have been colured.
Is it possible to fliter colums with cells that have been colured.
Take a look at this link, it may help?
http://www.xldynamic.com/source/xld.ColourCounter.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
try asap utilities add in
http://www.asap-utilities.com/asap-u...tilities=Range
this shows what it does just go to the homepage to download.
if however you are using excel 97
you need to download that version and color sort is done by a different method
see
http://www.asap-utilities.com/blog/i...sap-utilities/
Here's another add-in
http://www.rondebruin.nl/easyfilter.htm
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks