Macro to Copy Range and Paste in the Empty Row Same Sheet

**kaurka** · 04-22-2013, 09:19 AM

Hi

I would like to copy range A8:J15 to a the next empty row in the same sheet.

Any ideas?

Thanks

**arlu1201** · 04-22-2013, 09:24 AM

Try this

Please Login or Register  to view this content.

**kaurka** · 04-22-2013, 09:31 AM

I forgot to mention in the range i have merged cells.

**arlu1201** · 04-22-2013, 09:37 AM

Do you have a sample that you can upload?

Also can you show us where you want the data to be pasted?

**kaurka** · 04-22-2013, 09:40 AM

I dont have a sample i can upload.

But i would like to do the same as the code below for columns:

Please Login or Register  to view this content.

**arlu1201** · 04-22-2013, 09:51 AM

Try

Please Login or Register  to view this content.

**kaurka** · 04-22-2013, 09:58 AM

Getting an error

To do this, all the merged cells need to be the same size

**kaurka** · 04-22-2013, 10:00 AM

My range also has all the formatting and formulas that i would like to copy

**arlu1201** · 04-22-2013, 10:30 AM

Its better you attach a sample.

**kaurka** · 04-22-2013, 10:37 AM

See the attachment below

Issue List.xlsm

**AB33** · 04-22-2013, 10:50 AM

"To do this, all the merged cells need to be the same size"

The error message is: Need to unmerge cells.

**kaurka** · 04-22-2013, 10:51 AM

I have done this before with columns. See the CODE above

**kaurka** · 04-22-2013, 11:01 AM

I just figured it our myself but thanks for all your input.

Here's the Code:

Please Login or Register  to view this content.

Re: Macro to Copy Range and Paste in the Empty Row Same Sheet