|
- Sub tt()
- arr = [a1].CurrentRegion
- r = UBound(arr): c = UBound(arr, 2)
- ReDim brr(1 To Int(c / 13 * (r + 2) + 100), 1 To 13) '存放结果
- n = -r
- For j = 13 To UBound(arr, 2) Step 13
- If arr(1, j) = arr(2, j) Then '筛选条件
- n = n + r
- For i = 1 To r
- For k = 1 To 13
- brr(n + i, k) = arr(i, j - 13 + k)
- Next
- Next
- n = n + 1
- End If
- Next
- [p11].Resize(n + i - 1, 13) = brr
- End Sub
复制代码 |
|