Dim ws As Worksheet
Dim lastrow As Long
Dim i As Long
For Each ws In ThisWorkbook.Sheets
lastrow = 10000
For i = lastrow To 1 Step -1
If WorksheetFunction.CountIf(Rows(i), "空") > 0 Then
ws.Rows(i).Delete Shift:=x1up
End If
Next i
Sub 删除空行()
Dim ws As Worksheet
Dim lastrow As Long
Dim i As Long
For Each ws In ThisWorkbook.Sheets
lastrow = 10000
For i = lastrow To 1 Step -1
If WorksheetFunction.CountIf(ws.Rows(i), "空") > 0 Then
ws.Rows(i).Delete Shift:=x1up
End If
Next i
Next ws
End Sub