|
VBA如何加一个数组crr 一次输出结果到DE列
Sub test()
Dim i&, arr, brr(1 To 5, 1 To 2)
arr = [a1].CurrentRegion.Value
k = 1
For i = 1 To UBound(arr)
ss = Split(arr(i, 1), "|")
For j = 0 To UBound(ss)
brr(j + 1, 1) = Mid(ss(j), 1, 1)
brr(j + 1, 2) = Mid(ss(j), 2, 1)
Next
Cells(k, 4).Resize(5, 2) = brr
k = k + 6
Erase brr
Next
End Sub
'里面有代码
'如何把brr数组每一组 分别存入一个大数组crr
'一次输出结果到DE列
- Sub test()
- Dim i&, arr, crr, r&, ss
- arr = [a1].CurrentRegion.Value
- ReDim crr(1 To UBound(arr) * 6 - 1, 1 To 2)
- For i = 1 To UBound(arr)
- ss = Split(arr(i, 1), "|")
- For j = 0 To UBound(ss)
- r = r + 1
- crr(r, 1) = Mid(ss(j), 1, 1)
- crr(r, 2) = Mid(ss(j), 2, 1)
- Next
- r = r + 1
- Next
- [d1].Resize(UBound(crr), 2) = crr
- End Sub
复制代码
|
|