exact placement of copied rows

[chriswrcg]

I need to modify a macro that normally places a copied range at the bottom of the spreadsheet with each new copy becoming the bottom row.

The area on the worksheet I am using has the data to be copied and pasted in the center of the page. So if I am coping row 7 I need to place the first paste on row 8, then 9, then row 10 and so forth. If there is any content on the page below where I am pasting then that material needs to shift down so that it is not overwritten.

This is the current code.

Please Login or Register  to view this content.

[dflak]

This is "air code" - I'm too lazy to set up the spreadsheet.

Please Login or Register  to view this content.