Sub MyCount() [d1:d3] = 0 For i = 1 To Len(Range("A1")) Select Case Range("A1").Characters(Start:=i, Length:=1).Font.ColorIndex Case 1, xlAutomatic [d1] = [d1] + 1 Case 3 [d2] = [d2] + 1 Case 10 [d3] = [d3] + 1 End Select Next i End Sub
Sub MyCount() [d1:d3] = 0 For i = 1 To Len(Range("A1")) Select Case Range("A1").Characters(Start:=i, Length:=1).Font.ColorIndex Case 1, xlAutomatic [d1] = [d1] + 1 Case 3 [d2] = [d2] + 1 Case 10 [d3] = [d3] + 1 End Select Next i End Sub