上面的没看,仅查找部分的,可以用先把要查找的内容存入数组,然后对数组各值逐一查找。- Cells.Select
- arr = Array("PSG2 Test NT16 -", "(SOT23)", "(Reel No. Scan)", "PSG2 ", "Test NT16 -", " SOT23", _
- "Test Semicon (Manual) -", "Schedule Test -", " (Manual)", "_New processing", "Dispatch Test -", "BE-TM-")
- For i = 0 To UBound(arr)
- Selection.Replace What:=arr(i), Replacement:="", LookAt:=xlPart, _
- SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
- ReplaceFormat:=False
- Next
复制代码 |