Try the same thing to a new blank workbook. If it's the
same result the problem may actually lie with the Access
side. You could then try to copy and paste to a new book a
column at a time to find the troublemaker.
Ok, if it works in a clean blank book, you are back to
selecting the entire area the Access data covers and
checking the Formt->Cells->Alignment has no hint of a
check in the "merge cells" checkbox.
(e-mail address removed)
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.
-----Original Message-----
When copying columns of data from Access and pasting into
Excel, I receive an error stating "cannot change part of a
merged cell" and I'm not allowed to paste. But the cells
are not marked as merged! What do I do?
