Finding and deleting all rows with specific values.

[panda4444]

you guys are great! ok heres a new one.. maybe a simple one.

How can I find a text value and delete all that rows with the value in it?

For example.

There are three columns A,B,C
And I want to find all column C cells with then name NANCY and delete the WHOLE row including columns ABC associated with the Nancy value.???

I plan to put this in a macro.

 

[Mudface]

You could use an autofilter to show the rows you want to delete then just delete the visible rows. For an example, and a walkthrough to recording a macro to do this by Juan Pablo, take a look here-

http://216.92.17.166/board2/viewtopic.php?topic=32577&forum=2

 

[panda4444]

alright this one works great! So I went ahead and recorded it in a macro..

However, occasionally one problem occurs.

IF the macro does not find the value during the process the below link provides it gets hung up and wants to get debugged.

Is there a way to initate a search and if not found make the macro skip and try and find the next value to delete?

 

[panda4444]

BTW: here is the part of the macro I'm talking about....

Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:="=*bill**", Operator:=xlAnd
Application.Goto Reference:="R2:R65536"
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Delete Shift:=xlUp

the value here is "bill" when it does not find it, the macro stops.

 

[panda4444]

nevermind I figured it out!