6120| 9
|
求老司机带路,求VBA代码实现Sheet1曲线数据汇总到Sheet2,谢谢! |
2学分
最佳答案Sub test()
Dim A, B, i, j, x, y
Sheets(1).Select
A = Range([a4], Cells(41, 896))
ReDim B(1 To UBound(A), 1 To UBound(A, 2) / 8)
For j = 1 To UBound(A, 2) Step 8
'Debug.Print j \ 8 + 1 & "区"
'-------------------------------------->
x = 2 '指针
y = -1 '方向
For i = 1 To UBound(A)
B(i, j \ 8 + 1) = A(i, x + j - ...
| ||
发表于 2019-11-18 02:04
|
显示全部楼层
评分 | ||
发表于 2019-11-18 09:26
|
显示全部楼层
评分 | ||
发表于 2019-11-18 10:15
|
显示全部楼层
| |
| ||
| ||
发表于 2019-11-18 15:37
|
显示全部楼层
| ||
| ||