Delete Empty Rows

Does anyone know how I can delete empty rows using VBA?

Thanks in advance.

THanks for your reply, but that code isn't working for me. I am using the following code from the example:

Please Login or Register  to view this content.

But I am having to step through the worksheet manually. How can I loop through this quickly?

If there are empty cells on your spreadsheet, this will delete those rows.

Please Login or Register  to view this content.

Mike

When I use your code, it doesn't do anything. Is there something that I am doing wrong?