View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andre Kruger
 
Posts: n/a
Default Looping a selection of rows


Hi

I need to create a loop which will select 4 rows copy and paste it to a new
sheet. then go to the Next 4 rows and copy them to a new sheet. I need this
to happen untill the row is blank (empty).

Any idea how to do this loop?