(这两个是选择的或者是指定的某行With Rows("35:35"), Range("E37").Select
Sub 新插入()
'
' 新插入 Macro
' 宏由 ibm 录制,时间: 2015/01/14
'
'
With Rows("35:35")
.Insert Shift:=xlShiftDown
.Select
End With
Range("E37").Select
With Rows("37:37")
.Insert Shift:=xlShiftDown
.Select
End With
Range("E39").Select
With Rows("39:39")
.Insert Shift:=xlShiftDown
.Select
End With
Range("E41").Select
With Rows("41:41")
.Insert Shift:=xlShiftDown
.Select
End With
Range("E43").Select
With Rows("43:43")
.Insert Shift:=xlShiftDown
.Select
End With
Range("E45").Select
With Rows("45:45")
.Insert Shift:=xlShiftDown
.Select
End With
End Sub