Forum Discussion
Solved
Counting colored/blank cells in excel - nested macro
Hi all! Excel: Version 2312 Build 16.0.17126.20132) 64-bit I am using the https://www.ablebits.com/office-addins-blog/count-sum-by-color-excel/#:~:text=Insert%20the%20code%20of%20the,cell%20w...
I changed this line of the code
If indRefColor = cellCurrent.Interior.Color Then
to
If indRefColor = cellCurrent.Interior.Color And IsEmpty(cellCurrent) Then
and CountCellsByColor returns the intended result if i correctly understand what you are looking for.
I changed this line of the code
If indRefColor = cellCurrent.Interior.Color Then
to
If indRefColor = cellCurrent.Interior.Color And IsEmpty(cellCurrent) Then
and CountCellsByColor returns the intended result if i correctly understand what you are looking for.
Thank you so much!!!