Problem with VBA to Copy and Paste Rows

[Match12]

I use this very simple code to copy and paste rows - that include merged cells, conditional formatting and some dropdowns.

Sub Copy_rows()
 
  Range("A11:P11”).Copy
  Range("A12:P5000").Select
  ActiveSheet.Paste

End Sub

The idea is to copy everthing in Row 1 from A11:P11 into row 12 to 5000
Sometimes is works perfectly..other times it only copies down so far and then seem to fail to merge the cells. There is no consistency as to where it fails...other than roughly rows 1200 to 1350!

 

[Legacy 143009]

Try this. Maybe it would be more consistent:

Range("A12:P5000").Value = Range("A11:P11").Value

 

[Match12]

Try this. Maybe it would be more consistent:

Range("A12:P5000").Value = Range("A11:P11").Value

That did not seem to do anything?

Sub Copy_rows()

Range("A12:P5000").Value = Range("A11:P11").Value
End Sub

 

[Legacy 143009]

That did not seem to do anything?

Sub Copy_rows()

Range("A12:P5000").Value = Range("A11:P11").Value
End Sub

Maybe you should specify sheet names before ranges. That worked for me on the same sheet.

 

[Match12]

Did your test include Merged cells, borders, conditional formatting?
My problem seems to be the borders and merged cells more than anything else

 

[Legacy 143009]

Could you please share what the formatting looks like without values?

 

[Match12]

Starting in the column after "Model" those cells are merged, ,have borders, and contain Conditional Formatting.
One thing furhter investigation determined, the code always stops at row 1215!

 

[Legacy 143009]

Strange.. Try to clear everything before pasting. I have no idea other than this.

Sub Copy_rows()
 
  Range("A11:P11”).Copy
  Range("A12:P5000").Clear
  Range("A12:P5000").PasteSpecial Operation:=xlPasteAll

End Sub

EDIT: Somehow, it doesn't work. I hope this will work:

Range("A11:P11").Copy
 
  Range("A12").Resize(4089, 16).PasteSpecial

 

[Match12]

I am wondering, as it only goes to row 1215, if it is some type of memory issue...

 

[Match12]

I give up...will manually copy and paste!
Thank you for your suggestions! I am convinced it is a memory issue!