MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with Code

Posted by Jimmy on January 24, 2001 5:16 AM

What would the code be to copy a megered cell A84:I94 into a Word Object on another sheet. I can't seem to get the right code for copying and pasting the contents in the merged cells into the object on the new sheet.


Posted by AARON on January 24, 2001 8:53 AM

Don't use the A84:I94 as the reference.
Just use the upper leftmost cell reference.
Use A84 to refer to the merged cells.

Posted by Jimmy on January 24, 2001 9:15 AM

Arron thanks for the reply

I guess my real question is the actual syntax for the VB code to copy and paste the info in the merged cells into the Microsoft Word object on another sheet. I have tried recording a macro by going through the steps of copy the cells, changing sheets and then pasteing into the Word Object. It works fine doing it manually, but for some reason the syntax is not showing up in the macro and when I run the macro it goes up to the point of selecting the merged cells, but stops there. Any more help you can give would be greatley appreciated.