Delete Row if value less than - Quicker Solution?

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?

Maybe:

Please Login or Register  to view this content.

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 !