How to Replace multiple words to replace using excell

I have a list of bad 300 names that must be delete full row in
excell. I must do this every few days. Is there a way to Replace the multiple
replacement values into a command so I can replace the same list in a single
step?

Thank You

You could use a macro... would that be an acceptable solution to you? Create a range named
BadNames (preferably, on a separate sheet), then run this to delete rows where the 'Bad name'
appears in column A.

Sub TryNow()
Dim myRow As Long
For myRow = Range("A1").SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
If Not IsError(Application.Match(Cells(myRow, 1).Value, _
Range("Badnames"), False)) Then
Rows(myRow).Delete
End If
Next myRow
End Sub

HTH,
Bernie
MS Excel MVP


"ramsun" <[email protected]> wrote in message
news:[email protected]...
>I have a list of bad 300 names that must be delete full row in
> excell. I must do this every few days. Is there a way to Replace the multiple
> replacement values into a command so I can replace the same list in a single
> step?
>
> Thank You