在每行下面插入相同的行,可以用VBA编程来实现。360问答例如每行下面插入2行,其代码如下:
Sub 插入()
Dim I As Integer
I = 1
Do While Cells(I, 1) <> "" '判断首列为空时结束。可以根据实际情况做调整
Cells(I + 1, 1).Select
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Selection.EntireRow.Insert , CopyO久志多微乙科清孩职散rigin:=xlFormatFromLef觉某检纸孔例硫但促注按tOrAbove
I = I + 3
Loop
End Sub
运行前表格如图所示:
运行后如图: