- Sub today()
- Dim i%, j%, arr, s$
- Columns("e:e").Clear
- arr = Range("a1:e" & [a65536].End(3).Row)
- With CreateObject("vbscript.regexp")
- .Pattern = "[^D-W]"
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If InStr(s, arr(i, j)) = 0 Then s = s & .Replace(arr(i, j), "")
- Next
- arr(i, 5) = s: s = ""
- Next
- End With
- [e1].Resize(i - 1.1) = Application.Index(arr, , 5)
- End Sub
复制代码
|