Copying and Inserting Range of Rows After Last One Inserted

**swoosiebur** · 07-05-2013, 01:32 PM

Hello. I'm in desperate need of some VBA help. I'm trying to copy a range of rows from above, clear the contents and insert the copied rows below. It works the first time, but then always inserts the new rows above all of the old ones. How do I get the rows being copied to be inserted at the end of the of the last range of rows copied? I also need to do this for columns. Below is code that I recorded. Please help.

Please Login or Register  to view this content.

**venkat1926** · 07-06-2013, 07:03 AM

suppose sample data is like this entered in sheet 2 repeat 2
hdng1 hdng2 hdng3 hdng4
1 x x x
2 x x x
3 x x x
4 x x x
5 x x x
6 x x x
7 x x x

now run the macro test only

Please Login or Register  to view this content.

Please Login or Register  to view this content.

MODIFY TO SUIT YOU

**rollis13** · 07-06-2013, 10:23 AM

Have a try with this:

Please Login or Register  to view this content.

**swoosiebur** · 07-06-2013, 05:32 PM

Thanks so much for your help. It's still not doing what I need it to do. Perhaps I'll try to clarify. I need rows 6:25 to be copied and inserted below, below other rows of data (which would be shifted down). The newly copied rows would then need to be cleared and I would need to run this for as many times as I need to insert the new cells. Does this make sense. I new to this macro thing so I do really appreciate all of your help.

**rollis13** · 07-07-2013, 03:18 AM

Do you mean that every time you run the macro rows 6:25 need to be copied and then inserted starting at row 26 pushing down whatever found at 26 and below ?
If so, try:

Please Login or Register  to view this content.

**swoosiebur** · 07-07-2013, 01:47 PM

That's exactly what I'm looking for. Thanks so much! I'll give this a try when I get to work first thing tomorrow. I don't know about you, but learning macros is completely addicting. One more question. Will this macro work so that every time it's run, Rows "6:25" will be copied and pasted below the last range pasted.?

Thanks again for your help.