Selection Too Large Message

M

Martin

I have been getting the "Selection Too Large" message when pasting to about
12,500 rows (about 7 columns wide). The Excel newgroups showed a couple of
entries for this message.

I did some testing and, in my case, the problem seems to stem from the fact
that my source range (copied to the clipboard) is on a different worksheet
than the destination range is. If my source range and destination range are
on the same worksheet, everything seems fine.

I was curious if anyone else had seen this situation and if there is a way
around it. Is this a bug that will be fixed?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection Too Large Message 1
The picture is too large and will be truncated 1
Selection Too Large 0
PasteSpecial method of Range class failed Error 1004 8
Selection Too Large 1
Procedure too large 3
Selection is too large - when pasting formats programmatically 0
"Document is too large for Word to handle" message 6

Top