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.
|