I am trying to do the following:
I have a spreadsheet with 700 rowns. I would like to write a macro to copy a row and paste it 59 times, then go to the next row and paste it 59 times...until i get to row 700, whcih is the last row. I managed to write a macro to insert 59 rows for all 700 lines but i can't get the copying and pasting part done. Can someone suggest a macro for this?