Copying Data from a workbook to another workbook

P

Pam

I am trying to copy data in a merged cell from workbook/worksheet to another
workbook/worksheet where the receiving cell may be a different location and
different size.

This is to be done via a VB macro because I will be doing multiple worksheets.
 
M

marcus

Hi Pam

To the best of my knowledge you can't force differently shaped ranges
due to merging into one another. Merging cells is an unnecessary and
unneeded activity in XL. It is a long way from best practise and you
can get the same look and feel using basic formatting functions.

Go into your workbooks unmerge the merged cells - all of them. Now
your question title becomes one of the most commonly answered question
on this and other forums. You will find your answer in moments.

Take care

Marcus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top