|
楼主 |
发表于 2018-11-11 11:14
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 WYS67 于 2018-11-11 11:34 编辑
老师:代码应用到《2 组六》的数型时出错。
能不能让代码里的“中位”和“数型”调用《总表》K4里的内容?这样无论“中位”和“数型”或其它内容,都能运算。
Sub 拆分数型()
Dim ar, br, g, h, s, t, i, j, k, x, y
h = Sheets("总表").Cells(1, "h") - 4
ar = Sheets("总表").Range("e5:k" & h + 4)
g = UBound(ar, 2) - 1
For k = h To 1 Step -1
If ar(k, 1) <> "" Then Exit For
Next
For y = 1 To Worksheets.Count - 1
x = 0: ReDim br(1 To k, 1 To g)
For i = 1 To k
If ar(i, 7) = y Then
x = x + 1
For j = 1 To g
If j < 6 Then
br(x, j) = ar(i, j)
Else
If x = 1 Then
br(x, j) = br(x, 1) - 4
Else
br(x, j) = br(x, 1) - br(x - 1, 1)
End If
End If
Next
End If
Next
br(x + 1, g) = ar(k, 1) - br(x, 1)
s = Sheets("数型 " & y & "").Cells(1, "h") - 3
Sheets("数型 " & y & "").Cells(5, "e").Resize(s, 6) = br
Erase br
Next
End Sub
2 组六.zip
(928.97 KB, 下载次数: 3)
|
|