|
- Sub test()
- DoEvents
- Application.ScreenUpdating = False
- With Range("C1").CurrentRegion
- .Sort .Cells(1), xlDescending
- ss = .Value
- End With
- s = ss(2, 1)
- For i = 3 To UBound(ss)
- s = s & "|" & ss(i, 1)
- Next
- Set reg = CreateObject("vbscript.regexp")
- reg.Global = True
- reg.Pattern = s
- r = Cells(Rows.Count, 1).End(xlUp).Row
- If r = 1 Then r = 2
- ss = Range("a1").Resize(r).Value
- Range("a1").Resize(r).Font.Color = vbBlack
- For i = 1 To r
- If reg.test(ss(i, 1)) Then
- Set mas = reg.Execute(ss(i, 1))
- With Cells(i, 1)
- For Each ma In mas
- .Characters(ma.firstindex + 1, ma.Length).Font.Color = vbRed
- Next
- End With
- End If
- Next
- End Sub
复制代码 |
|