|
发表于 2017-4-15 20:04
|
显示全部楼层
本楼为最佳答案
是的,忘记加条件了
- Sub aaa()
- Dim arr, brr, i&, j&, k&, r&, c&
- arr = [a1].CurrentRegion
- r = 1
- ReDim brr(1 To -Int(-((UBound(arr) - 1) ^ UBound(arr, 2)) / 10), 1 To 10)
- For i = 2 To UBound(arr)
- If arr(i, 1) = "" Then Exit For
- For j = 2 To UBound(arr)
- If arr(j, 2) = "" Then Exit For
- For k = 2 To UBound(arr)
- If arr(k, 3) = "" Then Exit For
- c = c + 1
- If c = 11 Then
- c = 1
- r = r + 1
- End If
- brr(r, c) = arr(i, 1) & arr(j, 2) & arr(k, 3)
- Next k
- Next j
- Next i
- [a16].Resize(UBound(brr), 10) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|