View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default copy data from one sheet to another "entry has to be same shape"

des-sa

Just another bite of reality on the world of "Merged Cells". I would
un-merge the cells you are copying and use "center across selection". They
should copy and paste better. Hope this helps!

Mike Rogers

"des-sa" wrote:

hi
when i copy dat in cell a1 in sheet1 (which is merged with cells b1 and c1)
to cell d4 in sheet2, i get the message "data has to be same shape / size",
although the dat fill fit into the destination cell. is there a way to
overcome this?