Selection is too large

[Guest]

When I am trying to copy past row 21000, I get the message that the
"Selection is too large". I am try to copy only 1024 cells at a time (31
rows). Why Does Excel prevent me from coping more formulas. I have Excel
2003 and 2 gig ram.

 

[Guest]

Hi Charlie -

I don't think the situation you describe should produce that error.
However, if you exceed Excel or VBA's limitations on the number of
non-contiguous cells that can be copied, the 'Selection is too large' error
occurs. If you have a lot of hidden rows or cells in your selection, you may
be unintentioinally exceeding this limit. Otherwise, I'm not sure why the
error is occurring on your system.

Excel and VBA have a copy limit of 8,192 non-contiguous cells. In addition,
VBA has a copy/paste limit of 8,192 contiguous rows. Here is a link to an MS
KnowledgeBase article on the subject:

http://support.microsoft.com/kb/832293

Here is an excerpt -
"Typically, if you try to manually select more than 8,192 non-contiguous
cells, you receive the following error message:

The selection is too large.

However, when you use a VBA macro to make the same or a similar selection,
no error message is raised and no error code is generated that can be
captured through an error handler."