Quickest way to remove rows where sum or certain columns = 0

[JasperD]

Hi all,

I have a sheet with 800K rows, most of which are somewhat pointless.
Each row has data in columns A:X, but I want to keep only the rows where the sum of columns E:O isn’t zero.

I do this in a for loop like below, but it’s really slow. How can I make this quicker?

Please Login or Register  to view this content.

Obviously I turn off events, calculation and screenupdating.

Any better way to do this?

[dangelor]

Try using Autofilter to select the rows you want to delete, and then delete the visible cells.

[AlphaFrog]

Please Login or Register  to view this content.

[JasperD]

Sorry, I forgot to say that I used the 'delete empty rows' method, but it still took up to 30seconds or so, which is too slow.
I finally solved it using an array, which takes 4 seconds:

(AA contains my 800K row text file loaded in as array)

Please Login or Register  to view this content.