|Subject:||Delete blank rows|
|Posted by:||Andy B (email@example.com)|
|Date:||Thu, 2 Oct 2003|
After having imported a .prn file, I have sorted the data so that what I
need is at the top. I now have a couple of hundred lines of data that I
require and beyond that I have the headers, footers etc that I don't want.
As this will become a regular job, I would like a macro that will start in
cell E4, continue down the column, and when it finds a blank cell it deletes
the rest of the rows below.
Thanks in advance!!