Fix for "That command cannot copy multiple selections.".

G

Guest

How do you get rid of this error message when copying multiple selections
using COPY or Ctl+C. This error is forcing me to use Office 2003 because
the error is random and appears more often than not in Excel 2007.
Thanks
 
G

Gord Dibben

Are you saying you don't get that message when using Excel 2003 and try to
copy/paste non-contiguous ranges?

I certainly get the message on 2003 and previous versions.

No workaround as far I know.


Gord Dibben MS Excel MVP
 
J

Jon Peltier

If the selection is a rectangular range, or a series of areas that can be
mimicked as a rectangular range with whole rows or columns removed, then you
should be able to copy it, even though it's not a contiguously connected
range.

- Jon
 
G

Guest

I have gotten the message in 2003, but the problem is driving me nuts in
2007. It seems to occur nearly every time I attemot to copy several items.
Thanks for the answers.
 

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

Copy Multiple Rows Excel 1
Can't Copy and Paste when I'm using a filter List.. hmmm 1
copy and paste with multiple selections in Microsoft Excel 10
Cut Non Adjacent Rows in Excel 2007 1
copying non adjacent cells 2
Copy or Move a spreadsheet 1
copy excel cells to word without gridlines 1
Copy Multiple Selections thru Code 6

Top