Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count merged cells as if unmerged
I had this neat macro that counts how many cells are a certain color:
Public Function CountColors(color As String) As Integer Dim intCount As Integer Dim cell As Range For Each cell In Range("ThisRange").Cells If cell.Interior.color = 825735 Then intCount = intCount + 1 Next cell CountColors = intCount End Function The problem is, I have merged some cells. How can I get a macro to count say, 3 cells merged into 1 as three cells, not 1, if they match a certain color?. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count merged cells | Excel Worksheet Functions | |||
Count merged cells | Excel Discussion (Misc queries) | |||
Count with merged cells | Excel Discussion (Misc queries) | |||
Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells | Excel Worksheet Functions | |||
Retain value of merged cell in all unmerged cells | Excel Discussion (Misc queries) |