|
本帖最后由 laoau138 于 2017-6-8 12:04 编辑
VBA数组把A列拆分保存D列 改写加一个数组输出结果
Sub 按钮2_Click()
Application.ScreenUpdating = False
arr = [a1].CurrentRegion
a = 1
For j = 1 To UBound(arr) - 4
For i = j To j + 4
Cells(a, 4) = arr(i, 1)
a = a + 1
Next i
a = a + 1
Next j
Application.ScreenUpdating = True
End Sub
'VBA数组把A列拆分保存D列 改写加一个数组输出结果
'把A列数字每5个拆分一组保存D列 中间用一个空格隔开
'A列单元格存入数组arr
'把下面两句改写加一个数组brr输出结果到D列
'Cells(a, 4) = arr(i, 1)
' a = a + 1
本帖最后由 大灰狼1976 于 2017-6-8 10:55 编辑
- Sub aaa()
- Dim arr, brr, n&
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr) * 6 - 25 ,1 To 1)
- For i = 1 To UBound(arr) - 4
- For j = i To i + 4
- n = n + 1
- brr(n, 1) = arr(j, 1)
- Next j
- n = n + 1
- Next i
- [d1].Resize(n - 1) = brr
- End Sub
复制代码
|
|