View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default "Selection is too large" problem

This problem most often occurs when you try to "select" too many
discontinuous cells. Are you copying/pasting merged cells? This is the most
common cause.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Alan Howes" wrote:

I'm getting this message when copying two cells to an area 36x2 cells in MS
Excel 2007, in a workbook of about 5 Mb.

I can work round by (say) copying 1x2 into 4x2, then 4x2 into 36x2 - but
this should not be happening! It's not the first time I've had this, but it's
not a problem I always have.