本帖最后由 Jason_WangSS 于 2019-9-10 08:17 编辑
- Sub test()
- Dim arr, d As Object
- Dim i%, j%, x%
- Set d = CreateObject("Scripting.Dictionary")
- arr = Range("a3", Cells([a3].End(xlDown).Row, "K"))
-
- For i = 1 To UBound(arr, 1)
- brr = Join(WorksheetFunction.Index(arr, i, 0), ",")
- Do While InStr(brr, "")
- brr = Replace(brr, "", ",")
- Loop
- brr = Replace(brr, " ", ",")
- crr = Split(brr, ",")
- For j = 0 To UBound(crr)
- d(crr(j)) = crr(j)
- Next
- If d.exists("") Then d.Remove ("")
- Worksheets(1).Range("m10")(n + 1, 1).Resize(1, d.Count) = d.keys
- n = n + 1
- Set brr = Nothing
- d.RemoveAll
- Next
- End Sub
复制代码
|