Sub 删除空行() Application.ScreenUpdating = False Dim i&, Temp& For i = Range("B65536").End(xlUp).Row To 2 Step -1 If Len(Cells(i, 2)) = 0 Then Temp = Temp + 1 If Temp > 1 Then Rows(i).Delete End If Else Temp = 0 End If Next i Application.ScreenUpdating = True End Sub