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

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

Tallo-ho!
James

Reply With QuoteReply With Quote