View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Loops for deleting rows

ActiveSheet.UsedRange.EntireRow.Delete

--
Regards,
Tom Ogilvy

"daniB " wrote in message
...
I need to go through a spreadsheet and delete all odd rows.....I have
sooooo many rows that it takes forever and crashes....I need some VBA
which doesnt crash my spreadsheet!!!

Any ideas??

Thanks Dani


---
Message posted from http://www.ExcelForum.com/