I've got a massive excel sheet that I am trying to clean up by clearing out all rows that have a cell that contain either blank or a zero. I also need it to delete any row in that does not equal the number 3 in column "C".
The sheet is about ~148,000 rows long and I have to do this with 60 different sheets.
This is the code that I have written:
Now deleting the blank cells and the zeroes in columns "F" & "G" are no problem, it'll clear it up in a matter of seconds, but when it is trying to clean up column "C" it runs and runs and runs. Am I writing it incorrectly? Is there a more efficient way of doing this?
Please Login or Register to view this content.