Macro Deletes all rows except....

Try

Please Login or Register  to view this content.

Originally Posted by TheDriver85

How can I Delete all rows, except the rows that in Column "C" contain the word "DELV"

@AB33,

Did you test your solution before posting? The reason I ask, when deleting rows you should always step backwards and the OP wanted to keep the rows with "DELV".

Originally Posted by TheDriver85

Cool, it worked.

Can I ask what worked, which solution? Somebody following this thread may find it useful.

Originally Posted by AB33

Jeffrey!
Thanks!
You are right! I did not test it. It was a wrong code any way.

It just needed a few tweaks but it worked; however, I would opt for the filter method as it is a little more efficient than looping.

Glad you got what you needed and thanks for the feedback

-----------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save