Copying merged cells
Posted by Jimmy on January 16, 2001 8:23 AM
Is it possible to copy merged cells to another sheet if the merged areas are not the same size. I am using this code but keep getting an Error Message 1004 "Cannot Change Part of Merged Cell." The supcomments is merged cells from A84 to I93. Further down in the code it is mergeing cells A2:I40 on the Supervisors Comment sheet
With Sheets("Eval Form")
.Range("A83").Copy Sheets("Supervisor Comments").Range("A1")
.Range("supcomments").Copy Sheets("Supervisor Comments").Range("A2")
End With
What I am needing is a comment area to supervisors to add comments to the evaluation form. If they exceed the area allowed on the actual form I want to be able to use a macro and copy it to another sheet named Supervisor Comments that will print out when the form is printed. But I can't get it to copy and paste into a new sheet.
Thanks for any help.