Option Explicit
Dim myrng As Range, rowcount As Integer, criteria As Range, cell As Variant, criteriaIndex As Long
Dim tempcounter As Long
Function countColoredcells(ByVal criteria As Range) As Long
rowcount = Sheets(3).Range("A1").End(xlDown).Row
Set myrng = ThisWorkbook.Sheets(3).Range("A1:A" & rowcount)
tempcounter = 0
criteriaIndex = criteria.Interior.ColorIndex
For Each cell In myrng
If (cell.Interior.ColorIndex = criteriaIndex) Then
tempcounter = tempcounter + 1
End If
Next
countColoredcells = tempcounter
End Function
Dim myrng As Range, rowcount As Integer, criteria As Range, cell As Variant, criteriaIndex As Long
Dim tempcounter As Long
Function countColoredcells(ByVal criteria As Range) As Long
rowcount = Sheets(3).Range("A1").End(xlDown).Row
Set myrng = ThisWorkbook.Sheets(3).Range("A1:A" & rowcount)
tempcounter = 0
criteriaIndex = criteria.Interior.ColorIndex
For Each cell In myrng
If (cell.Interior.ColorIndex = criteriaIndex) Then
tempcounter = tempcounter + 1
End If
Next
countColoredcells = tempcounter
End Function
No comments:
Post a Comment