Sub 隔行插入()
Dim t1, t2, t3, x
t1 = Application.InputBox("请输入从第几行开始执行隔行插入", "插入提示")
t2 = Application.InputBox("请输入插入的次数", "插入提示")
t3 = Application.InputBox("请输入插入的字符串", "插入提示")
For x = Val(t2) + Val(t1) To t1 + 1 Step -1
Rows(x).Insert
Cells(x, 1) = t3
Next x
End Sub
改自4楼
Sub 隔行插入3()
Dim t1, t2, t3, x
t1 = Application.InputBox("请输入从第几行开始执行隔行插入", "插入提示")
t2 = Application.InputBox("请输入插入的次数", "插入提示")
t3 = Application.InputBox("请输入要复制的单元格,默认为A1", "插入提示", "A1")
For x = Val(t2) + Val(t1) To t1 + 1 Step -1
Rows(x).Insert
Range(t3).Copy Cells(x, 1)
Next x
End Sub