|
发表于 2014-6-19 09:54
|
显示全部楼层
本楼为最佳答案
- Sub t()
- Dim arr, brr, re(), n(9), i&, j%, k%, d As Object, s As String * 1
- arr = Range("I3:P5").Value
- brr = Range("I7:P9").Value
- Set d = CreateObject("scripting.dictionary")
- ReDim re(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- For k = 1 To Len(arr(i, j))
- s = Mid(arr(i, j), k, 1)
- d(s) = ""
- Next
- For k = 1 To Len(brr(i, j))
- s = Mid(brr(i, j), k, 1)
- d(s) = ""
- Next
- re(i, j) = Join(d.keys, "")
- d.RemoveAll
- Next
- Next
- Range("I13").Resize(UBound(re), UBound(re, 2)) = re
- End Sub
复制代码 |
|