| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| Delete all but first line | Excel Discussion (Misc queries) | |||
| way to test line before / after, without !REF if delete? | Excel Discussion (Misc queries) | |||
| how to delete to the end of line | Excel Programming | |||
| Macro to delete line | Excel Programming | |||
Linear Mode
