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
|