第1个回答 2017-05-05
Sub s()
sn = [l1]
en = [n1]
stp = [t1]
arr = [a2].CurrentRegion
cc = 1
i = 1
Do Until arr(i, 1) = sn
i = i + 1
Loop
sl = i
Do Until arr(i, 1) = en
i = i + 1
If i = UBound(arr) Then Exit Do
Loop
el = i
ReDim brr(sl To el, 1 To 33)
For i = sl To el
For j = 3 To 8
If arr(i, j) <> "" Then brr(i, arr(i, j)) = arr(i, j)
Next
Next
Cells(sl + 1, 32).Resize(el - sl + 1, 33) = brr
Dim crr(1 To 21)
For i = 1 To 33
For j = sl To el - stp * 3
If brr(j, i) <> "" Then
For k = 1 To (el - j) / stp / 3
If brr(j + stp * k, i) <> "" And brr(j + stp * k * 2, i) <> "" And brr(j + stp * k * 3, i) <> "" Then
crr(cc) = brr(j, i)
cc = cc + 1
GoTo nexti
End If
Next
End If
Next
nexti:
Next
[j28:ad28] = crr
End Sub来自:求助得到的回答本回答被提问者采纳