Delete row based on single cell value

[The Phil]

Hi,

I'm trying to delete entire rows when column K has the value TRUE in it (this is a text value, not a formula result).

I'm trying the following code.

Please Login or Register  to view this content.

This seems to work, but EXTREMELY slowly. I can see it deleting a row every few seconds, but my spreadsheet is over 12,000 rows. Is it because of the way it is set to loop? Is there a way to edit this so that it will work faster? It may be best if it starts at the end of the sheet, since that is where most of the TRUE values will be.

Thanks!

[judgeh59]

is it possible you have a bunch calculations happening?...

add this to the beginning of your code

Please Login or Register  to view this content.

add this to the end

Please Login or Register  to view this content.

see if this helps....


and Yes, when deleting rows it's usually better to work from the bottom and go up....

but that doesn't usually make it slow doing your way....

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.