Copy & Paste Merged Cells

[Darren Smith]

Trying to copy merged cells to Merge cells.
It copies fine but won`t paste?
Error is 1004 Application-defined or object-defined error

                Private Sub Jobcard_Demands_Change()

         If Jobcard_Demands = ("Details to Jobcard Analysis Sheet") Then
     
            Dim SourceLastrow As Long
            Dim wsDest As Worksheet

           Set wsSource = ThisWorkbook.Sheets("Job Card Master")
           Set wsDest = ThisWorkbook.Worksheets("Job Card with Time Analysis")
            
            SourceLastrow = wsSource.Range("A" & Rows.Count).End(xlUp).Row
            wsSource.Range("A2:N" & SourceLastrow).Copy
                
      

                     wsDest.Range("A2").MergeArea.PasteSpecial xlPasteValues
            

                  
End If

End Sub

 

[Darren Smith]

Sorry worked it out don`t worry anymore