|
- Sub tt()
- arr = [a1].CurrentRegion
- s = Val(InputBox("请输入拆分次数"))
- r = UBound(arr)
- For i = 0 To s - 1 '拆分次数
- rc = r - 3 * i '最大行
- p = rc / 3 '1/3处
- ReDim brr(1 To r / 3, 1 To 11)
- For k = 1 To rc
- If k <= p Then
- n = n + 1
- brr(n, 1) = arr(k, 1): brr(n, 2) = arr(k, 2): brr(n, 3) = arr(k, 3)
- ElseIf k <= 2 * p Then
- m = m + 1
- brr(m, 5) = arr(k, 1): brr(m, 6) = arr(k, 2): brr(m, 7) = arr(k, 3)
- Else
- l = l + 1
- brr(l, 9) = arr(k, 1): brr(l, 10) = arr(k, 2): brr(l, 11) = arr(k, 3)
- End If
- Next
- Sheets.Add after:=Sheets(Sheets.Count)
- With ActiveSheet
- .Name = "第" & i + 1 & "次"
- .[a1].Resize(UBound(brr), 11) = brr
- End With
- n = 0: m = 0: l = 0
- Next
- End Sub
复制代码 |
|