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/