|
- Sub UcaseIt()
- Dim rng As Range, strMark$
- Dim Arr, k%, iLen%
- For Each rng In ActiveSheet.UsedRange
- strMark = "": iLen = 0
- If Len(rng) Then
- Arr = Split(" " & rng, " ")
- For k = 1 To UBound(Arr)
- iLen = iLen + Len(Arr(k - 1)) + 1
- If Arr(k) = "of" Or Arr(k) = "and" Then
- ElseIf Arr(k) Like "[a-z]*" Then
- strMark = strMark & " " & iLen
- Arr(k) = UCase(Left(Arr(k), 1)) & Mid(Arr(k), 2, Len(Arr(k)))
- End If
- Next
- If Len(Trim(strMark)) Then
- rng = Trim(Join(Arr))
- Arr = Split(strMark, " ")
- For k = 1 To UBound(Arr)
- rng.Characters(Start:=Arr(k), Length:=1).Font.Color = vbRed
- Next
- End If
- End If
- Next
- End Sub
复制代码 |
|