Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete blank rows
I have Excel spreadsheets that are created from a double-spaced text file and
another application. Most of the resulting spreadsheet has a blank row after each row of data. How can I create a macro to get rid of these blank rows? Ideally, I want to start this process after a row of equal signs (=====) and end when it gets to a row of dashes (----) as these divide the header and footer where I prefer not to delete the blank rows. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete blank rows | Excel Discussion (Misc queries) | |||
Delete Blank Rows | Excel Discussion (Misc queries) | |||
Delete all blank rows... | Excel Discussion (Misc queries) | |||
delete blank rows | Excel Discussion (Misc queries) | |||
Delete blank row only if 2 consecutive blank rows | Excel Programming |