Thread: Deleting a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Zone Zone is offline
external usenet poster
 
Posts: 269
Default Deleting a row

Looks like you want to delete ALL the rows that have nothing in column
E. When deleting rows, start from the bottom of the worksheet.

For j=cells(65536,"e").end(xlup).row to 1 step-1
if cells(j,"e")="" then rows(j).delete
next j

This may not be as elegant as some solutions (meaning it might take a
bit longer), but it will work.
James