Insert rows between rows without replacing existing data.

**m-steele@shaw.ca** · 08-15-2012, 03:29 AM

I am having a problem with the following macro.

Here is the scenario and what i am trying to do:

I have an excel sheet with about 7000 rows in it.

I need to copy 23 rows of data at the top of the sheet that contain formulas.

I need to paste / insert these 23 rows of data between every existing row in the sheet.

So for example

Line 1
< insert 23 copied rows here
Line 2
< insert 23 copied rows here
Line 3
< insert 23 copied rows here
Line 4
< insert 23 copied rows here
etc, etc...

My problem:
The proper rows are copied and they seem to be pasted every second row (i think) but the pasted rows are over writting the rows below them.it. Another words this isn't really inserting the rows as much as it is pasting the rows every second row and overwriting any data.

I need to fix this so that it does not overwrite anything. I want the 23 rows to be inserted between existing rows and keep all existing rows.

The code that I am using is below. I have a header row and the 23 rows I want to copy start on row A3. The first insert should be between row 26 and row 27.

Please help me fix this! Thank you in advance!

Please Login or Register  to view this content.

**JapanDave** · 08-15-2012, 05:03 AM

Something like this,

Please Login or Register  to view this content.

**m-steele@shaw.ca** · 08-15-2012, 11:39 AM

One problem with this is that it only inserts the first column of date between rows. I need this to copy and insert the entire row.

It seems to insert rows properly but it only inserts the first column of data. How can we change this so that it copies entire rows and inserts the entire row between each existing row?

I cant figure out how you change the range to be the entire row of data.

Also, how do you control which cell the copied data starts from?

I have attached a cpoy of what i am working on. This is only a sample of the data.

SailData_MainSails_08_15_2012-testing.xlsm

Thanks