HELP - DELETE EMPTY ROW
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.
Jiminey
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:
http://www.mrexcel.com/wwwboard/messages/15006.html
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
