Excel 2007 : Count colored cells in vba

[nlm]

Hi,

How to count the cells with yellow highlight color in vba?

Thanks.

[alansidman]

Look at this for a starting point.

http://www.datapigtechnologies.com/f...rtonColor.html

Alan

[nlm]

Thanks Alan!

The link was very helpful and the issue has been solved.

[royUK]

There's an alternative example here

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save