View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
George Nicholson[_2_] George Nicholson[_2_] is offline
external usenet poster
 
Posts: 170
Default Delete 2 rows skip 1 delete 2 more

I know you said you wanted a macro, but if you are only doing this once, it
only takes 30 seconds to do it manually:

- Add a helper column
- In the 1st three cells of that column enter A, B, C.
- Copy those 3 cells down the length of your data
- Sort on the Helper column.
- Delete A's & B's

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"jared" wrote in message
oups.com...
I am looking to have a macro delete 2 rows then skip 1 row and delete
the next two. I have over 18,000 rows and I really would rather not do
this the manual way. :)

Thanks,
Jared