Macro to delete rows in Col B where the values are zero

I have written code to delete rows containing zeroes in Col B from sheet 6 onwards (row 2 onwards)


When running the macro, it goes into a loop and I need to shut down Excel


It would be appreciated if someone could kindly assist me in resolving this

Please Login or Register  to view this content.

Well,
The code loops through many sheets and then loops again in column B for each sheet. When it deletes the row, it selects the entire row.
I suggest, you should use a filter which is much faster, or you could put in all the rows to be deleted in a range as a collection and do a single delete.

Thanks for the help, Jeff. Code works perfectly

Thanks for the advise

Also posted on Mr Excel.com

https://www.mrexcel.com/forum/excel-...oes-col-b.html