本帖最后由 云影 于 2014-7-8 17:50 编辑
- Sub test()
- Dim arr, x%, Str$, d As Object
- arr = Range("a1").CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For x = 2 To UBound(arr)
- If Not d.exists(arr(x, 1)) Then
- Str = Str & "," & arr(x, 1)
- End If
- d(arr(x, 1)) = ""
- Next
- Range("D4") = "'" & Mid(Str, 2)
- End Sub
复制代码 或- Sub test()
- Dim arr, x&, Str$, d As Object, rng As Range
- arr = Application.InputBox("请选择数据源", "提示", , , , , , 8)
- Set d = CreateObject("scripting.dictionary")
- For x = 2 To UBound(arr)
- If Not d.exists(arr(x, 1)) Then
- Str = Str & "," & arr(x, 1)
- End If
- d(arr(x, 1)) = ""
- Next
- Set rng = Application.InputBox("请选择存放地址", "提示", , , , , , 8)
- rng = "'" & Mid(Str, 2)
- End Sub
复制代码 |