第2个回答 2012-10-26
==========================================================================
按Alt+F11,输入以下代码:
Sub 隔行插入()
Application.ScreenUpdating = False
Dim i%, j%, x%, y%
x = 1 '间隔行数
y = 1 '插入行数
With ActiveSheet
For i = 1 To y
For j = 1 To .[A65536].End(xlUp).Row + Int(.[A65536].End(xlUp).Row / (x + i - 1))
If j Mod (i + x) = 0 Then .Rows(j).Insert
Next j
Next i
End With
Application.ScreenUpdating = True
End Sub
回到Excel,按Alt+F8,运行改宏便可。