Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from a workbook to another workbook
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Data from a workbook to another workbook
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Data from one workbook to another | Excel Programming | |||
copying worksheets to a new workbook without formulae referencing original workbook | Excel Programming | |||
Copying data from workbook/sheets to another workbook/sheet | Excel Programming | |||
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming |