LinkBack URL
About LinkBacks
I have this UDF which counts the number of cells with a specific colour.
It works fine unless the colours are very similar to each other. Why is this? Any way to sort it out?
Please Login or Register to view this content.
I have this UDF which counts the number of cells with a specific colour.
It works fine unless the colours are very similar to each other. Why is this? Any way to sort it out?Please Login or Register to view this content.
check vba help for colorindex, it can see only 56 colors
If solved remember to mark Thread as solved
Thanks for that.
Is there a way to take into account all colours?
Failing that, is there any easy way of telling a user which colours are within the 56 so they only use those?
try using rCell.Interior.Color (RGB colors)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks