Here's a piece of code from the mvps.org site that deletes all blank rows in
a spreadsheet, if that's what you're trying to do.

http://www.mvps.org/dmcritchie/excel...emoveEmptyRows

-Allen



"Andy" wrote:

Does someone has some code that will delete all blanks line in spread sheet.
They may not be exactly every other but any blank line in excel spread sheet.

thanks
Andy