我希望根据单元格中包含“upg”或“upgrade”这些词的单元格值来删除行。当单元格中存在这些单词时,它们并不是唯一的单词。
这是我的代码的一部分,它没有删除任何内容:
Sub DeleteValues()
Dim i As Integer
Dim MFG_wb As Workbook
Dim Dep As Integer
Set MFG_wb = Workbooks.Open _
("C:\Users\rosipov\Desktop\eliran\MFG - GSS\MFG Daily\Fast Daily " & Format(Now(), "ddmmyy") & ".xlsx", _
UpdateLinks:=False, IgnoreReadOnlyRecommended:=True)
MFG_wb.Sheets("Aleris").Activate
Dep = MFG_wb.Sheets("Aleris").Range("B2").End(xlDown).Row
For i = Dep To 2 Step -1
Cells(i, 2).Select
If Not (Selection.Value = "& upg &" Or Selection.Value = "*& upgrade &*") Then
Rows(i).Delete
End If
Next i
End Sub
以下是问题:
For i = Dep To 2 Step -1
Cells(i, 2).Select
If Not (Selection.Value = "& upg &" Or Selection.Value = "*& upgrade &*") Then
Rows(i).Delete
End If
Next i