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

I am assuming that I woould replace "e" with c but what would I replace "j"
with? Can I simplify it by just stating row instead of rows"j".delete?

"Zone" wrote:

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