Hi all,
I'm trying to copy large amounts of data yet excel keeps posting the error message,
Is there anything I can get around this.... there are merged cells within the workbook.Please Login or Register to view this content.
Hi all,
I'm trying to copy large amounts of data yet excel keeps posting the error message,
Is there anything I can get around this.... there are merged cells within the workbook.Please Login or Register to view this content.
Last edited by Steve-B; 01-20-2009 at 05:10 AM.
If you are copying merged cells, I'm pretty sure you need to ensure the range where you are pasting is either identically merged, or you need to unmerge the cells (where you will be pasting) before pasting.
HTH
Jason
Always try and avoid merge cells whenever possible. Sometimes is better to take longer in designing the layout of the spreadsheet as can avoid issue like this.
If possible I would use centre across selection instead
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thanks peeps.
Yes merged cells are not at all a great idea.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks