Deleting rows containing certain values

[walrasianxl]

Hi all,

I want to delete rows containing certain values: For example, this is a rough picture of what i have:

Name1 Name2 Value
Amy Eric 24
Ted Chris 18
Jon Liza 20
Amy Eric 11
Amy Annie 15

I would like to delete "Amy" from the column "Name1". How do i go about doing it?

Many thanks!

[Marcol]

Try this in a standard module

Please Login or Register  to view this content.

Hope this helps

[EDIT]
If you just want to delete "Amy" and not the whole row use Replace > Find What:= "Amy" > Replace With:= Leave this field blank

[Palmetto]

Another option using filtering, which is faster than looping.
User is prompted via an input box to enter the name, which is passed to the filter as the critiera.

Note: this code uses the sheet code name -- not the worksheet name. You can replace "Sheet1" with "ActiveSheet" to make the code a bit more generic.

Please Login or Register  to view this content.