Sub TEST()
ARR = Range("G5:G" & Range("G65536").End(3).Row)
Set D = CreateObject("scripting.dictionary")
For I = 1 To UBound(ARR)
D(ARR(I, 1)) = ""
Next
Range("S5:S65536").ClearContents
Range("S5").Resize(D.Count) = Application.Transpose(D.KEYS)
End Sub
Sub TEST()
ARR = Range("G5:G" & Range("G65536").End(3).Row) '将数据赋予数组
Set D = CreateObject("scripting.dictionary") '建立字典
For I = 1 To UBound(ARR) '数组循环
D(ARR(I, 1)) = "" '建立key(不重复值)
Next
Range("S5:S65536").ClearContents '清除原数据
Range("S5").Resize(D.Count) = Application.Transpose(D.KEYS) '粘贴数据
End Sub