|
发表于 2021-6-27 17:21
|
显示全部楼层
本楼为最佳答案
Dim a, ar, c, d, n, m, r, num
Sub demo()
Set d = CreateObject("Scripting.Dictionary")
Select Case Application.Caller
Case "按鈕 1": g = 1: n = [e1]: m = [g1]: c = "a": [a2:ao1000] = ""
Case "按鈕 2": g = 2: n = [au1]: m = [aw1]: c = "aq": [aq2:ce1000] = ""
Case "按鈕 3": g = 3: n = [ck1]: m = [cm1]: c = "cg": [cg2:dy1000] = ""
End Select
ReDim num(1 To 1, 1 To m)
a = Sheets(1).UsedRange
ar = (g - 1) * (n + 1)
r = 1: com 1, 1
End Sub
Sub com(k, i)
If k > m Then
r = r + 1
Cells(r, c).Resize(1, m) = num
Cells(r, c).Offset(, 7).Resize(1, d.Count) = d.keys
Exit Sub
End If
For i = i To n - m + k
num(1, k) = a(ar + i, 1)
For j = 2 To UBound(a, 2)
Key = a(ar + i, j)
If Key <> "" Then d(Key) = d(Key) + 1
Next
com k + 1, i + 1
For j = 2 To UBound(a, 2)
Key = a(ar + i, j)
If Key <> "" Then
d(Key) = d(Key) - 1
If d(Key) = 0 Then d.Remove Key
End If
Next
Next
End Sub
祝順心,南無阿彌陀佛!
|
评分
-
查看全部评分
|