Blank lines

[David O'brien]

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?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/excelM.htm#DeleteBlankRows

 

[Tom Ogilvy]

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