MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jiminey Dehey on January 18, 2002 9:16 PM

The current macro I have to delete empty rows is lousy and stops working for no reason. I need a good solid macro that will delete empty rows. Can someone help please.


Posted by Tom Urtis on January 18, 2002 10:47 PM

If you hit Ctrl+F, it will bring up the Find dialog box, and you can enter a keyword such as "delet" (for posts with headers containing delete, deleting, or deletion), or "row". You will find several posts on this topic.

Bob Umlas answered a similar question recently and you will find his macro to delete rows here:

And of course there are other macros which may be useful to you, depending on what condition(s) may determine whether a row should be deleted (blank cell, cell containing ceratin value, etc.), so hunt around using the Find box and you will find a macro to suit your needs.

Good luck.

Tom Urtis