View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bioyyy bioyyy is offline
external usenet poster
 
Posts: 22
Default Delete every other two row MACRO

Hello:

I need a macro to delete every other rows starting from row2. For example
Col B
Row2: Test1-a
Row3 Test1-b
Row4 Test1-c
Row5: Test2-a
Row6: Test2-b
Row7: Test2-c

In other words, I'd like the macro to delete row 3-4 (b-c) and 6-7 (b-c),
and so on

Thanks again,