Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Replace multiple words to replace using excell
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace several words to One | Excel Discussion (Misc queries) | |||
multiple sets words replace | New Users to Excel | |||
can I save a file of multiple names to replace using excell 03 | Excel Discussion (Misc queries) | |||
Replace words from ADO recordset | Excel Programming | |||
Excel to replace words ? | New Users to Excel |