Entirerow.delete

No need for a while loop and for next loop with back ward looping will do the job.

Please Login or Register  to view this content.

Thank you,

that works flawlessly!!!

Can you explain why the code I was using was skipping rows?

It would be easy to solve it if you could attach a sample to see why the code skips rows.

Hi,

I attached a spreadsheet with a simillar macro that should delete the empty rows.
I have to run this macro several times until all rows have been deleted. Strange!?

Please Login or Register  to view this content.

I get that for some reason it does work with Step -1. I lack to understand why it does not work with the other code.

Both go row by row and evaluate the cell content and delete the row subsequently, right?

Why is Step - 1 accurate and my code is not?

If you want to delete or insert a row in VBA, you should loop back ward (Step -1), not forward. If you do not, the code will skip a row as you delete them.

I understand now. Makes sense. I delete then the next row becomes the current row meanwhile the algorithm jumps to the next row thereby skipping the current row.
Thanks for helping me out.