View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
craig51 craig51 is offline
external usenet poster
 
Posts: 2
Default duplicate a row with a macro

Hello all,

In excel, I want to write a macro that will do the following.

Lets say I have a sheet with 300 rows

I want to copy the first row, and paste this 180times in a separate worksheet.

Once its done this, move to the second row, and repeat the above, with it
being pasted under what i just did above, until its at the end of all the
rows.

Anyone got a scooby on how to do this!

Cheers