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?