VBA - Copy Paste Error (Merged Cells)

[paulcherianc]

Hi Experts!

I am not able to copy paste the range to another sheet as I am having some merged cells on the Sheet "Signatories" which needs to be placed on the Sheet "TANP". Can anyone help me to fix this!

 Sub Signatories()

Worksheets("Signatories").Range("A1:AN15").copy

With Sheets("TANP").Range("J" & Rows.Count).End(xlUp).Offset(1, 0)
     .PasteSpecial xlPasteFormats
     .PasteSpecial xlPasteValues
End With

End Sub

 

[Chihiro]

Don't use merged cells. Ever. It's nothing more than visual fluff and complicates further data analysis and visualization.

If you use it, you must be willing to suffer consequences.

Now, having said that. There are ways to work around it, but you'll need to provide sample workbook with enough data and manually created expected output for us to help you effectively.

 

[paulcherianc]

I will take your Advise. Ignored that merged area!!

Thanks!

 

[SirJB7]

Hi, paulcherianc!
Instead of merged cells use Center In Selection.
Regards!