Delete Row if value less than - Quicker Solution?

[batchy]

Hello,

I've created the following code which deletes rows if the value in column G is less than 10.

Please Login or Register  to view this content.

The issue is its a very time consuming. Can anyone recommend a faster solution?

[Norie]

Filter column G for values less than 10 and then delete en masse?

[sintek]

Hi batchy
Add this in beginning of code:

Please Login or Register  to view this content.

And this in end

Please Login or Register  to view this content.

[sintek]

Try this code of xld's...Much faster

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Marc L]

Hi !

With big data as SpecialCells method has a limit and as clearing consecutive rows is faster than deleting row by row,
the tip is to use a temp additional column to mark rows to clear (aka 0 - 1 or False - True)
then sort entire range on that additional column in order to move rows to clear at the bottom of range,
clear rows and additional column, that's it !