操作可以通过定位空格,ctrl+回车多单元格输入公式来完成。
或者试下面的代码- Sub 根据列值插入空行_芐雨()
- Dim arr, maxRow&, i&, j&, x&, brr(1 To 100000, 1 To 12)
- maxRow = Cells(Rows.Count, 1).End(3).Row
- arr = Range("A1:L" & maxRow) '区域,可自行修改
- For i = 2 To UBound(arr)
- x = x + 1
- For k = 1 To 12
- brr(x, k) = arr(i, k)
- Next
- If arr(i, 8) > 1 Then '数量大于1
- For j = 1 To arr(i, 8)
- x = x + 1
- For k = 1 To 12
- brr(x, k) = arr(i, k)
- Next
- brr(x, 8) = 1
- brr(x, 11) = arr(i, 11) / arr(i, 8)
- Next
- End If
- Next
- Range("A2").Resize(x, 12) = brr '输出数组
- End Sub
复制代码 |