Sub 插入()
Dim i%
For i = Range("a65536").End(3).Row To 2 Step -1
Rows(i).Insert Shift:=xlDown
Next
End Sub
Sub 删除()
Dim k%
For k = Range("a65536").End(3).Row To 2 Step -1
If Cells(k, 1) = "" Then
Rows(k).Delete
End If
Next
End Sub
Sub 插入()
Dim i%
For i = Range("a65536").End(3).Row To 2 Step -1
Rows(i).Insert Shift:=xlDown
Next
End Sub
Sub 删除()
Dim k%
For k = Range("a65536").End(3).Row To 2 Step -1
If Cells(k, 1) = "" Then
Rows(k).Delete
End If
Next
End Sub