Delete every other line
 

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

Delete every other line
 

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

Delete every other line
 

Thank you Boss. This is great.

Andy

"Allen Geddes" wrote:

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