Thread: Blank lines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David O'brien David O'brien is offline
external usenet poster
 
Posts: 1
Default 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?