|
楼主 |
发表于 2019-4-12 15:26
|
显示全部楼层
老师:需要加在下面代码的哪个地方?
Function QCSX(sjy As Range)
Application.Volatile
Dim arraylist As Object, arr, x, y, r
arr = sjy
Set arraylist = CreateObject("system.collections.arraylist")
For Each r In arr
If Not (IsError(r)) Then
If r <> "" Then
If Not arraylist.contains(r) Then arraylist.Add r
End If
End If
Next
arraylist.Sort
x = arraylist.toarray
Set arraylist = Nothing
ReDim y(1 To UBound(arr), 1 To 1)
For i = 0 To UBound(x)
y(i + 1, 1) = x(i)
Next
For i = UBound(x) + 2 To UBound(arr)
y(i, 1) = ""
Next
QCSX = y
End Function
|
|