Got a different version No problem, you can still follow the exact same steps.

You have better things to do than scroll through hundreds of rows right-clicking and deleting.

It had a single blank cell, but the entire row has been removed.

If you forget this step, you wont filter the entire dataset.

One last step: just let us know where should we should send it.

Im trying to go through the document ( A1:Z50 ) and for each row where there is no data in the cells ( A1-B1.Z1 empty, A5-B5.Z5 empty ) I want to delete them.

I need to check an entire row (A1-Z1) to see whether its empty or not, and this down to A50-Z50.

If there arent any items in any of these cells (A1 to Z1) then the row is empty and can be deleted.

Someone else who might have the same problem will be helped with your example though;).

It will find the last realrow in each sheet and delete the remaining blank rows.

It also works outside of Excel e.g.

Excel by Access-VBA or VB6.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged vba excel or ask your own question.

Delete Empty Rows Excel For Mac