Deleting rows by specific values very slow

[Vaslo]

Hello,

I am using the following code to delete rows that are useless to me:

Please Login or Register  to view this content.

It is extremely slow having to go row by row through 100k rows. Is there a better way to speed up this type of process? One advantage is that the 0's being searched for are in large groups together typically because this is an unpivot of crosstabular data. Thanks!

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Vaslo]

repped
Significantly sped it up - thank you.

[jeffreybrown]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. As Jeff said please mark this thread as SOLVED.