|
以下是代码
Sub 按单元格去重()
Dim dic As Object, cel As Range
Set dic = CreateObject("scripting.dictionary")
Sheets("需去重数据").Activate
For Each cel In ActiveSheet.UsedRange
dic(cel.Value) = 1
Next
Sheets("去重结果").Activate
Range("A1").Resize(dic.Count, 1) = Application.Transpose(dic.keys)
End Sub
麻烦大神帮忙解答以下~
本帖最后由 望帝春心 于 2017-2-6 19:06 编辑
- Sub 按单元格去重()
- Dim dic As Object, cel As Range
- Set dic = CreateObject("scripting.dictionary")
- Sheets("需去重数据").Activate
- For Each cel In ActiveSheet.UsedRange
- dic(cel.Value) = 1
- Next
- Sheets("去重结果").Activate
- For Each k In dic.keys '这样改一下
- n = n + 1
- Cells(n, 1) = k
- 'Range("A1").Resize(dic.Count, 1) = Application.Transpose(dic.keys)
- Next
- End Sub
复制代码改下缩进
|
|