delete unnecessary rows

Hi guys!

I just want to ask what codes could delete the rows with zeros? Please note that the data set is just a sample and I will be handling more bulks of data like these so the code should not be restricted to the number of cells in the attached excel file.

Thanks in advance!

I am trying it but it already took 15 minutes and it is still having a hard time processing.

What's wrong with this? It takes forever to process. It's still not working

maybe so

Please Login or Register  to view this content.

Dear nilem, run time error occurs when I use the code.

Dear MarvinP,
Thank you for the code. I was able to understand the code, thank you very much for that, but I really wonder why it's not working for the other data sets. After 15 min. processing, it worked for the sample I've given..but for more bulky data sets, the time takes much longer.

Hm... I can not reproduce the error. Try again

The problem with the code is that it arranges the data into ascending order, but the data should not be sorted. The rows with zeros should be deleted but the rows with true values should retain their order.

then try so

Please Login or Register  to view this content.

yes, it works! Thank you so much to you, nilem and MarvinP!

Just for curiosity's sake, will this work for you (on a copy of your workbook)

Please Login or Register  to view this content.