|
本帖最后由 爱疯 于 2019-10-6 20:32 编辑
Sub CommandButton1_Click()
Dim A(1 To 500, 1 To 4), B, rng '如果500不够,再改大
Dim x, y, s, i, j
B = Array(11, 11, 15, 15) '几个大组,其中各有几个小组
For i = LBound(B) To UBound(B) '遍历大组
For j = 1 To B(i) '遍历小组
s = s + 1 '数组A的计数
x = (9 + i) + (y * 3) + ((j - 1) * 3 + 1)
Set rng = Cells(Rows.Count, x)
Set rng = Columns(x).Find("*", rng, , , , 2)
If Not rng Is Nothing Then A(s, 1) = rng: A(s, 2) = rng.Offset(0, 1)
Next j
y = y + B(i) '小组的累计
s = s + 1
Next i
[d:e] = ""
[d7].Resize(s, 2) = A
End Sub
2.rar
(226.48 KB, 下载次数: 6)
|
|