Sub mydel() Dim i%, Erow%, s 'Erow = [A65536].End(3).Row For i = 10 To 1 Step -1 s = InStr(1, Cells(i, 3), ".doc") If s = 0 Then Rows(i).Delete End If Next End Sub
Sub mydel() Dim i%, Erow%, s 'Erow = [A65536].End(3).Row For i = 10 To 1 Step -1 s = InStr(1, Cells(i, 3), ".doc") If s = 0 Then Rows(i).Delete End If Next End Sub