I have this VBA code that is taking about 20 minutes to run through 100K rows in a excel sheet. The code is to look for the word "M13" and when it finds it, it's to delete the whole row of data.
Is there a way to speed up this process? The code listed below:
Is there a way to speed up this process? The code listed below: