Delete blank rows

Giganews Newsgroups
Subject: Delete blank rows
Posted by:  Andy B (andy@removethisbit.dawsons.co.uk)
Date: Thu, 2 Oct 2003

Hi all

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

Andy.

Replies