- Sub test()
- Dim ar, br, MyRange As Range
- Dim wr
- On Error Resume Next
- Set ar = Application.InputBox(prompt:="请输入开始单元格", Title:="提示", Default:="请选择", Type:=8)
- ar1 = ar.Row
- On Error Resume Next
- Set br = Application.InputBox(prompt:="请选择需要插入的行", Title:="提示", Default:="请选择", Type:=8)
- br1 = br.Row
- wr = InputBox("请问隔几行插入", "提示", "隔几行")
- aend = Range("a65536").End(xlUp).Row '取得最后行号
- Application.ScreenUpdating = False
- For i = ar1 + wr To aend Step wr '从ar开始循环到最后一行,步长为wr(每隔wr行插入)
- n = n + 1
- Rows(i + n).EntireRow.Insert Shift:=xlDown '整行插入
- Rows(br1).Copy Cells(i + n, 1)
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |