View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Deleteing Blank Rows

assume if the cell is blank in column A, then the row should be deleted

Columns(1).specialCells(xlblanks).EntireRow.Delete

--
Regards,
Tom Ogilvy


"dayton" wrote in message
...
In my macro I need to delete rows that are blank down to the end of the
file. The file's will not always be the same. What would the code be for
this?

T.I.A.