deleting empty rows

Hi,

I need to write a macro which checks cells in one column and if the cell is empty it deletes the whole row (which contains the cell).

I tried this code but it doesn't delete all rows with empty cells:

Please Login or Register  to view this content.

So I modified the code:

Please Login or Register  to view this content.

It works correct but it is not a proper solution (it ends the for loop after 20 deleted cells)...

Do you have any better suggestions?

Thanks!

You need to iterate from bottom to top when you're deleting rows. Think about it ...

hi Kaipan,

Welcome to the Forum
... have you tried searching for a solution before posting your question?

The macro that you have shown is designed to only check the rows between row 7 & row 25 as stated by the initial For statement & because of this, it appears it was written for a very specific purpose. Your modified attempt does recognise that once a row is deleted, the counter becomes inaccurate if the macro runs from the top to the bottom of the data, because of this it is wise to process from the bottom up (eg http://j-walk.com/ss/excel/tips/tip56.htm).

If the above link isn't the best approach for you, "Delete row macros" are commonly asked about & I think you'll find a solution with a quick glance at some of the links on the below search:
http://www.google.co.uk/#hl=en&sourc...14e9eaa343dff4


hth
Rob

Please Login or Register  to view this content.

...or if the cells are true blanks (not formula nulls) then (avoiding iteration):

Please Login or Register  to view this content.

Thanks for the feedback & marking the thread as solved - I'm pleased we could help :-)

Rob