Dim x As Integer
Dim y As Integer
Dim z As Integer
Dim r As Integer
z = Sheets("单位工程总材料计划").[B65536].End(xlUp).Row
For x = 6 To z
For y = 8 To 19
r = Cells(x, y).Value
If Cells(x, y).Value <> 0 Then '满足条件就退出内循环
Exit For
End If
Next y
If r = 0 Then ‘当内循环完成后判定是否为0
Rows(x).Select
Selection.Delete Shift:=xlUp
End If
Next x
End Sub 以上语句在满足为零的单元格删除不完 请教啊
Z = Sheets("单位工程总材料计划").[B65536].End(xlUp).Row
For x = Z To 6 Step -1
For y = 8 To 19
If Cells(x, y).Value = 0 Then
Rows(x).Delete
Exit For
End If
Next
Next
Z = Sheets("单位工程总材料计划").[B65536].End(xlUp).Row
For x = Z To 6 Step -1
For y = 8 To 19
If Cells(x, y).Value = 0 Then
Rows(x).Delete
Exit For
End If
Next
Next