|
要求:点击按钮1的时候,需要先清除D列单元格内容,再执行以下代码。不然会有上次的残留操作内容。 |
|
|
|
|
Sub 唯一值()
Dim arr, i%, j%, u%, brr(), k%
arr = [a1].CurrentRegion
u = UBound(arr)
ReDim brr(1 To u)
For i = 1 To u
If i < u Then
For j = i + 1 To u
If arr(i, 1) = arr(j, 1) Then arr(j, 1) = ""
Next j
End If
If arr(i, 1) <> "" Then k = k + 1: brr(k) = arr(i, 1)
Next i
Range("D1").Resize(k) = Application.Transpose(brr)
End Sub
|
添加一句columns(4).clearcontents
|
|