Carim - Went to Chip's Site - Noted that he uses

CountByColor = CountByColor - _
' (Rng.Interior.ColorIndex = WhatColorIndex)

to return either a 0 (False) or a 1 (True)

Confused with CountByColor MINUS 0 or 1 <<
Here the True must be coming through as the
Traditional TRue = -1 so that 0 Minus -1 = 1
Can you straigthen me out in my confusion?

TIA,

Jim May

"Carim" wrote:

Hi,

Take at look at Chip's brilliant solution :

http://www.cpearson.com/excel/colors.htm

HTH
Carim