looks interesting, ill try it tomorrow, but my original idea stands. There
are usually many ways to do things in excel, but sometimes program coding can
do it best.

"Gord Dibben" wrote:

bobz666

Have you tried F5SpecialBlanksOK?

Then EditDelete. Entire Row or Shift up or left.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 16:05:01 -0800, "Simon Shaw"
wrote:

can you not filter for the blanks prior to importing?

"bobz666" wrote:

I frequently import large data files in which data overflows the column
creating blank lines plus there are also blank/incomplete data records.
Deleteing the blanks involves turning on autofilter, selection that column,
scrolling to the bottom of data in the list box to the "blanks" and selecting
it. then selecting all the row numbers that is lists, deleting the rows, then
hitting show all data again.