Sub Click()
Dim r%, A, i%, s$
Application.ScreenUpdating = False
r = Cells(Rows.Count, 4).End(xlUp).Row
A = Range("d1:d" & r)
For i = 1 To r
If InStr(A(i, 1), "有") Then s = s & "," & i & ":" & i
Next i
Range(Mid(s, 2)).Delete
End Sub Book1b.rar(8.77 KB, 下载次数: 3)