Delete rows from a LARGE dataset

Hi
I have a code that works, but takes a LONG time (5 mins when I timed it). Have a very large dataset that needs to loop through different columns and delete rows based on criteria...

I was hoping to find a faster way to do it since there are over 40,000 lines.

I had seen a post that mentioned sorting the data first, but I'm not sure how this would help as the marco would still need to loop through all 40000 lines to find the info.. then go line by line to delete which is apparently where the slowness comes in when its so large.

Here is the current code.. I have many of these as I'm doing clean-up on many columns. Any tips would be greately appreciated!

Please Login or Register  to view this content.

Hi! I tried the autofilter but when I ran the "macro" I'd created, it deleted all the rows not only the ones filtered