Run-time error '1004': We Can't do that to a merged cell

[Sarche]

I wrote a VBA code that was working until a few days ago now I am getting an error message that is can't do that to a merged cell when trying to copy and paste. However, there are no merged cells in the section that is being copied and pasted. Below is the code that keeps throwing the error message. I cannot figure out why I keep getting this message. Here is a link to a sample worksheet for the entire code.

20-8010 - FAIRMOUNT CHATTSWORTH STATION - Sample.xlsm

Select Case Sheets("Job2Date").Range("A1") = ""
Case True
Sheets("Job2Date").Range("O7:R701").Copy Sheets("Job2Date").Range("A7")
Case False
Sheets("Job2Date").Range("O7:R701").Copy Sheets("Job2Date").Range("XFD7").End(xlToLeft).Offset(0, 1)
End Select

 

[MAP77]

I'm also a newbie to VBA and I am having this same error.
Can I ask, is it ok to still have merged cells that are not in the ranges specified in the code? Eg. would the code only throw this error when looking at the specified ranges and it finds a merged cell?

 

[jolivanes]

Normally you should start your own thread under a banner like "How to prevent possible problems with merged ranges"
The first bunch of people will probably echo previously mentioned suggestion to not use it.
However, what was your result when you tried to copy and paste outside of the merged range(s)?