Locate Specific Text and Delete the Entire Row

@leebird
As, I assume, you noticed in walruseggman's code, selecting is very seldom required and it slows down the macro as well.
Your "Cells.Select" selects 17,179,869,184 Cells (1,048,576 Rows x 16,384 Columns)
Looking at your code, youre not working with 17+ million cells.
Similar for the "Columns("M:M").Select". Here you select 1,048,576 Cells. Hardly required by the looks of it.
There are lots of ways to work with only the "used cells".
For a Column, one of the possibilities would be
Range("M1:M" & Cells(Rows.Count, "M").End(xlUp).Row)

Just for practice purposes, put the following code in a regular Module and see what the result is.

Please Login or Register  to view this content.

You'll notice that it only selects from M1 to the last used Cell in Column M

If you use the method in your code for formatting you'll see that the size of your workbook will be very big after saving and that it will get slower and slower.
If you would Google "Excel File Size Increased" or "Bloating Excel Files" or something similar you'll find some examples of this.

Just some friendly pointers. No negative intentions at all. We all started out this way
I feel generous today. After all, our local football team got the cup yesterday.
If you have any questions that will make your Excel life easier, make sure to come back here and someone will help you.

Test.xlsm

Hello,

Hmmm I don't seem to be having any luck. I have added a sample attachment. Ideally I'm hoping to go through column M and replace the empty cells with the text "No Description" next, go to column W and replace the empty cells with the text "Delete", next search for duplicates in column V and delete those rows, next search through column V for cells that contain (20000, 22005, 22025, 22000 and 60-)and
delete those rows, last autofit the whole page.

Sorry, my original macro does seem long, still working through the shortcuts

Thanks so much

Try

Please Login or Register  to view this content.

Don't know how much data (number of rows) you have in the file as I assume the upload is a small sample. If so I think I would start getting rid of duplicates and rows that contains "60-", "2200" and so fort in order to reduce the number of rows to check for blank values in column M and V.

So adding a few bits and pieces to jindons's code you could try this:

Please Login or Register  to view this content.

Alf

This worked great! Thank you very much. Wonderful macro.

Thank you very much! I can definately re-use this code in another project I'm working on.

You are welcome and thanks for feedback.

Alf