開通VIP,暢享免費(fèi)電子書等14項(xiàng)超值服
首頁
好書
留言交流
下載APP
聯(lián)系客服
2019.05.25
Sub 提取唯一()
Dim arr
Dim d As New Dictionary
arr = Range("a1", [a1].End(xlDown))
For x = 1 To UBound(arr)
d(arr(x, 1)) = ""
Next x
Range("g1").Resize(d.Count) = Application.Transpose(d.Keys)
End Sub
微信登錄中...請(qǐng)勿關(guān)閉此頁面