Need to maximize efficiency of simple macro because of large excel file

I wrote a macro that worked relatively well when I used it on 10,000 or so rows. Now that I am using it on 300,000+ rows, I need to make sure it is as efficient as possible. I'm not proficient enough to maximize it's efficiency any further and am looking for help. Any know any ways to increase speed of this task?


Basically all I need is all rows that have "Closed" in column H to be gone. This has to be done ever day and so efficiency is definitely a factor. I'm trying to automate the process from start to finish so I can focus on other things.


My initial thought is there way be a way to do this without actually having to select each cell individually?

___________________________________________________________

Please Login or Register  to view this content.

____________________________________________________________