View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robotman@gmail.com is offline
external usenet poster
 
Posts: 13
Default Delete every other line in LARGE worksheet

Can anyone think of a FAST way to delete every other line in a 45,000
line worksheet?

I can do a loop with Range("A"&Loop).EntireRow.Delete, but it takes
almost 10 minutes.

I was thinking of somehow selecting every other line and doing one HUGE
delete, but not sure if Excel could handle that or if it would be any
faster.

Any ideas?!!

Thanks.