|
发表于 2013-2-7 16:15
|
显示全部楼层
本楼为最佳答案
- Sub STR1()
- Dim rng As Range, i As Integer, m As Integer
- For i = 1 To 23
- m = 0
- If Application.WorksheetFunction.Sum(Range("B5:G5").Offset(i)) Then
- For Each rng In Range("B5:G5").Offset(i)
- If rng.Font.Color = 255 Then m = m + 1
- Next
- Range("H5").Offset(i) = m
- End If
- Next i
- End Sub
- Sub STR2()
- Dim rng As Range, AC, i As Integer, m As Integer, n As Integer
- For Each rng In Range("M6:M23")
- If rng <> "" Then
- m = 0
- n = 1
- For Each AC In Split(rng)
- If AC <> "" And rng.Characters(n, Len(AC)).Font.Color = 255 Then m = m + 1
- n = n + Len(AC) + 1
- Next
- rng.Offset(0, 3) = m
- End If
- Next
- End Sub
复制代码 |
|