Entering the following formula into the formula bar, the number of cells in Column E that contain the color in E2 are counted
The user-defined worksheet function works fine but I would like to get the whole thing automated, i.e. ...
... to write this formula into B7 of the worksheet named 'Results' of the active workbook
... and the counting of the shaded cells is to be effected in Column E of a sheet named 'Evaluation' and where E5 is the cell reference that contains the background color (to be counted).
... The range of cells can be any number, e.g. E1:465 or E1:3244, i.e the range is variable
It would be great if somebody could help me with that. Help is much appreciated. Thank you very much in advance.
Function CountByColor(CellColor As Range, CountRange As Range)
Dim ICol As Integer
Dim TCell As Range
ICol = CellColor.Interior.ColorIndex
For Each TCell In CountRange
If ICol = TCell.Interior.ColorIndex Then
CountByColor = CountByColor + 1