Blank lines
 

I have a workbook with lots of data (20,000+ rows) and
some of these are blank - the whole line may not be blank
but if there is no value in column a i would like to
delete the whole line - does anyknow know how to do this?

Blank lines
 

Hi
have a look at
http://www.cpearson.com/excel/excelM...eleteBlankRows

--
Regards
Frank Kabel
Frankfurt, Germany

David O'brien wrote:
I have a workbook with lots of data (20,000+ rows) and
some of these are blank - the whole line may not be blank
but if there is no value in column a i would like to
delete the whole line - does anyknow know how to do this?

Blank lines
 

Columns(1).SpecialCells(xlBlanks).EntireRow.Delete

--
Regards,
Tom Ogilvy


"David O'brien" wrote in message
...
I have a workbook with lots of data (20,000+ rows) and
some of these are blank - the whole line may not be blank
but if there is no value in column a i would like to
delete the whole line - does anyknow know how to do this?