Sub test()
Sheets(2).Columns("A").ClearContents
Set d = CreateObject("scripting.dictionary")
For Each cl In UsedRange
If cl <> "" And cl.Row <> 1 Then d(cl.Value) = ""
Next
Sheets(2).Range("a1").Resize(d.Count, 1) = Application.Transpose(d.keys)
End Sub
我加了红色那句!,另发现数据导出少了一个,最后一句代码更正一下!
Sub test()
Sheets(2).Columns("A").ClearContents
Set d = CreateObject("scripting.dictionary")
For Each cl In UsedRange
If cl <> "" And cl.Row <> 1 Then d(cl.Value) = ""
Next
Sheets(2).Range("a1").Resize(d.Count, 1) = Application.Transpose(d.keys)
End Sub
我加了红色那句!,另发现数据导出少了一个,最后一句代码更正一下!