Copy a range WITH formatting and values

**janschepens** · 03-09-2012, 03:10 PM

Hi I'm in need of a macro that copys a range (A3:H5) to the active cell selected but cannot get it to complete this. Can someone please help me out? This is the code I'm currently using:

Please Login or Register  to view this content.

But this will only copy the row above it and insert it right below.

**tigeravatar** · 03-09-2012, 03:14 PM

janschepens,

(OP wrapped code in code tags - thank you)
Give this a try:

Please Login or Register  to view this content.

**janschepens** · 03-09-2012, 03:17 PM

thank you so much this works but fails in the center of a sheet. i need it to be able to insert into the middle of a spreadsheet without overwriting existing data for example: insert copied cells would be ideal to assign this macro button to

**Winon** · 03-09-2012, 03:26 PM

What about just:

Please Login or Register  to view this content.

**janschepens** · 03-09-2012, 03:33 PM

Winon your code is perfect except it does not insert into the middle of a spreadsheet. Can you please help me with this last detail? Can we some way make it to do "Insert copied cells?"

**Winon** · 03-09-2012, 03:40 PM

Hello janschepens,

Do you actually mean that you want the macro to insert additional rows, and then paste the data?

**janschepens** · 03-09-2012, 03:45 PM

Hi Winon,

I want to paste the copied data into the selected cell and have the data/rows below it move down automatically and remain untouched.

**tigeravatar** · 03-09-2012, 03:58 PM

janschepens

Please Login or Register  to view this content.

**Winon** · 03-09-2012, 04:27 PM

@ tigeravatar,

Thank you. Nothing wrong with that.

You were just a bit faster than me, while I was looking at something else.

**Winon** · 03-09-2012, 04:46 PM

Hello janschepens,

I am quite confident that your problem is now sorted out. Please test the code you were given and if you are satisfied, then please see the notes at the bottom of this Post.

Thank You.