Private Sub CommandButton1_Click() Dim srt, fnd As String fnd = "@mail.ru" i = 1 txt = Cells(1, 1) Do While txt <> "" txt = Cells(i, 1) If InStr(1, txt, fnd) = 0 Then Rows(i).Delete MsgBox InStr(1, txt, fnd) End If i = i + 1 Loop End Sub