Sub RowDel()
Dim k As Integer
For k = Cells(Rows.Count, 2).End(3).Row To 1 Step -1
If Cells(k, 2).Value = "已过期" Then Cells(k, 2).EntireRow.Delete
Next k
End Sub
Sub RowDel()
Dim k As Integer
For k = Cells(Rows.Count, 2).End(3).Row To 1 Step -1
If Cells(k, 2).Value = "已过期" Then Cells(k, 2).EntireRow.Delete
Next k
End Sub