ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Selection is too large" problem (https://www.excelbanter.com/excel-discussion-misc-queries/244969-selection-too-large-problem.html)

Alan Howes[_2_]

"Selection is too large" problem
 
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.

Luke M

"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.



All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com