View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default error on spreadsheet

hi
somewhere on the large spreadsheet that you are coping are merged cells.
you can copy merged cells but you can only paste the merged cells in merged
cells of the same size. excel rule.
solution.
1. find and un-merge the cells on the copy sheet
2. set up merged cells on the paste sheet - same size-same place.

note: this is one reason i recomment that merged cells NOT me used.

regards
FSt1

"Kp7131" wrote:

I am copying a large spreadsheet - I am getting an error.
THIS OPERATION REQUIRES THE MERGED CELLS TO BE IDENTICALLY SIZED

CAN ANYONE TELL ME WHAT THIS MEANS?

I WOULD APPRECIATE IT.

THANK YOU

KP