View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default countbycolor counts all cells in a merged cell

Everyone is supposed to know where you got the countbycolor module?

If you post the code, then perhaps someone can advise how to modify it.

--
Regards,
Tom Ogilvy

"dsamson" wrote in
message ...

I have multiple merged cells, each with any of 3 possible colors. When
I use the countbycolor module, it counts all the cells in the merge
area. What I want is to count the merge areas, not the individual
cells, by color. Any hints?


--
dsamson
------------------------------------------------------------------------
dsamson's Profile:

http://www.excelforum.com/member.php...o&userid=35528
View this thread: http://www.excelforum.com/showthread...hreadid=552955