If Cell Equals "" Delete Row Macro

[shawn2209]

I am needing a macro formula for if a cell = "DELETE ME" then it will delete that row.

 

[Trebor76]

My last macro in thread 9 should do exactly what you're asking in thread 10

Make a copy of the workbook (via Windows or SaveAs) and try it.

 

[shawn2209]

Thank you so much Trebor76. That works great. I do have another question. If I want it to delete cells A:F and Move data up after deletion. What macro would I need for that?

 

[Trebor76]

Not sure I'm afraid as in my mind deleting the row working backwards would do that??

There'll be someone here who will be able to solve it for you I'm sure.

Good luck with it.

Robert

 

[Peter_SSs]

If I want it to delete cells A:F and Move data up after deletion.

If you do that, your formula in column L on that row will return a #REF! error because the cells in columns B, D, E & F that the formula on that row refers to will have been deleted.