写好了,代码如下:Option ExplicitSub 提取不重复值() Dim objRange As Range Set objRange = Sheet1.Range("A2:C100")
Dim dctData As Object Set dctData = CreateObject("scripting.dictionary")
Dim objSubRange As Range For Each objSubRange In objRange dctData.Item(CStr(objSubRange.Value)) = Null Next
Dim i As Integer i = 2
Dim varKey As Variant For Each varKey In dctData Sheet1.Cells(i, "F") = varKey i = i + 1 Next
MsgBox "提取完成!" End Sub下载地址: 链接:https://pan.baidu.com/s/18Ds2VICCOVnd5UgU9q9DRQ 提取码:cr2g 运行示例:
Sub test() arr = Range("A2:C100") Set d = CreateObject("scripting.dictionary") For j = 1 To UBound(arr) For i = 1 To UBound(arr, 2) d(arr(j, i)) = "" Next i Next [d2].Resize(d.Count) = WorksheetFunction.Transpose(d.keys) MsgBox "提取完成!" End Sub
Dim objRange As Range
Set objRange = Sheet1.Range("A2:C100")
Dim dctData As Object
Set dctData = CreateObject("scripting.dictionary")
Dim objSubRange As Range
For Each objSubRange In objRange
dctData.Item(CStr(objSubRange.Value)) = Null
Next
Dim i As Integer
i = 2
Dim varKey As Variant
For Each varKey In dctData
Sheet1.Cells(i, "F") = varKey
i = i + 1
Next
MsgBox "提取完成!"
End Sub下载地址:
链接:https://pan.baidu.com/s/18Ds2VICCOVnd5UgU9q9DRQ
提取码:cr2g 运行示例:
arr = Range("A2:C100")
Set d = CreateObject("scripting.dictionary")
For j = 1 To UBound(arr)
For i = 1 To UBound(arr, 2)
d(arr(j, i)) = ""
Next i
Next
[d2].Resize(d.Count) = WorksheetFunction.Transpose(d.keys)
MsgBox "提取完成!"
End Sub