|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Dim r, d
Sub 按钮1_Click()
Dim brr()
Set d = CreateObject("scripting.dictionary")
arr = [a1].CurrentRegion
ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
r = 0
For j = 2 To UBound(arr)
If Not d.exists(j) Then
d(j) = j
r = r + 1
For i = 1 To UBound(arr, 2)
brr(r, i) = arr(j, i)
Next i
dg arr, brr, j
End If
Next j
[h2].Resize(UBound(brr), UBound(brr, 2)) = brr
End Sub
Sub dg(arr, brr, x)
For j = x + 1 To UBound(arr)
If InStr(arr(j, 1), arr(x, 2)) > 0 Then
r = r + 1
For i = 1 To UBound(arr, 2)
brr(r, i) = arr(j, i)
Next i
d(j) = j
dg arr, brr, j
End If
Next j
End Sub
|
评分
-
1
查看全部评分
-
|