Excel: Copy cells in row 12 and paste those rows at row 17. If row 17 is full then row 18 and so on

Hello I'm having a lot of trouble trying to write a macro that will copy the cells in row 12 and then paste the data in those cells into row 17. Once row 17 has been filled I want the next lot of data from row 12 to be pasted at row 18 and so on. What I'm doing is I'm enter data into some cells at row 12 and once this is completed I'm clicking the macro button and I want that data to be pasted at the next available line starting at row 17 I had a go at writing a macro but it seems to add a blank line at row 17 and then everything starts from row 18. What am I doing wrong? Thanks Alan Sub SaveTrade() ' ' SaveTrade Macro ' ' Range("C12:U12").Select Selection.Copy Range("C17:U17").Select ActiveSheet.Paste ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.EntireRow.Insert Shift:=xlDown End Sub

This question generated 29 answers. To proceed to the answers, click here.

This thread is current as of July 25, 2014.

For more resources for Microsoft Excel