|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Public Sub test()
Dim Arr, Brr
Dim LastR As Long
Dim ZhouQi As Long
Dim i As Long, j As Long, m As Long
LastR = Range("i1048576").End(xlUp).Row
Arr = Range("I5:I" & LastR)
ZhouQi = Range("L3")
ReDim Brr(1 To (UBound(Arr) - 1) / ZhouQi + 1, 1 To ZhouQi)
m = 1
For i = 1 To UBound(Arr)
j = i Mod ZhouQi
If j = 0 Then j = ZhouQi
Brr(m, j) = Arr(i, 1)
If j = 3 Then m = m + 1
Next i
Range("L5").Resize(UBound(Brr), ZhouQi) = Brr
End Sub
|
评分
-
1
查看全部评分
-
|