|
单击按钮,输入数量试试!{:1712:}- Sub tc()
- Dim sl As Long, bh As Long
- bh = Cells(5, 3).Value
- sl = Application.InputBox("请输入填充数量", "提示")
- Application.ScreenUpdating = False
- Cells(10, 1).Resize(Rows.Count - 9, 7).Clear
- For i = 1 To sl
- Range("A1:G8").Copy Cells(9 * i + 1, 1)
- Cells(9 * i + 5, 3) = Format(bh + i, "00000")
- Cells(9 * i + 6, 6) = Format(bh + i, "00000")
- Next i
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|