Deleting rows based on a cell value

This video will outline one way to delete rows based on a cell value in a spreadsheet, via the use of a simple VBA macro in Excel.

[tunbergtunis]

You are a god! Finally a person that makes a simple and good way to explain how to make this! I thank you and Salute you!

[tannertucker]

This is excellent. Anyway to delete rows that contain dates in a given column? Thank you.

[lourdesgonzalez]

How would I delete a row that contains a string in a cell. I need to remove all lines that have the string "vlv" but the cell contains vlvdsf2121 and or also 5421vlv1256. How can I do this? thank you.

[alexbezdicek]

Very helpful and well explained. How do you apply it to different columns?

[geetikaluthra]

You are good!! But what if we want to delete only specific rows (eg B and C) if in case the column in I is blank? Please suggest

[mhods]

Love the macro! However I am dealing with 20, 000+ Lines of data. I just ran it and it worked beautifully, but it took over an hour to run. Any way to shorten this time? Thanks!

[Gstudios]

Got an error: "Can't execute code in break mode". Any tips?

[onekenzo]

the code works, but it actually deletes all rows, despite the fact that there are other values in the column, like 1, 2, etc. What should I do?

[ranjitseth]

Hi, how do I change the loop "For Each ws In Worksheets" to " only the worksheet named ' Hour', so that the operation does not apply to all the worksheets in the workbook except "Hour". Thanks