JimC
12-04-2007, 08:55 AM
When Pasting text from another source (not excel) I get a Microsoft Excel Warning "Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
Click ok
Another Excel warning comes up, "Cannot change part of a merged cell."
Is there a way to force the cell to accept the pasted text?
Maybe an automatic macro that unmerges the cell, pastes the text, then remerges the cell again? This only seems to happen when copying from an a non-excel file. Any advise would be appreciated...
Thanks....
Click ok
Another Excel warning comes up, "Cannot change part of a merged cell."
Is there a way to force the cell to accept the pasted text?
Maybe an automatic macro that unmerges the cell, pastes the text, then remerges the cell again? This only seems to happen when copying from an a non-excel file. Any advise would be appreciated...
Thanks....