Copy & Paste with Merged Cells Above and Below|VBA & Macros|Excel Forum|My Online Training Hub

Hello

I am wanting to copy and paste a range per the script below. None of the cells I am copying & pasting from/to are merged. 

Sheet4.Range("N6:U7").Copy Range("L6:S7")
Sheet4.Range("N9:U10").Copy Range("L9:S10")
Sheet4.Range("N12:U12").Copy Range("L12:S12")

The first line works but the macro stops on the second line and gives the following run-time error:

run-time error '1004'

We can't do that to a merged cell.

To get past this, I enter into cells N9:S10 and re-run the macro which then works. 

Can someone please tell me how to get around this error without unmerging the cells above and below?