By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,659 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,659 IT Pros & Developers. It's quick & easy.

Excel 2010: Move Block

P: 1
I am SIMPLY trying to copy an entire row from one EXCEL workbook (hi-lite the entire row by clicking on the row # at the left side of page, then right-click and select copy), and insert a copy of it into another workbook using "insert copied cells" (right-click on the row number, then insert copied cells). I have been performing this very same function for years using EXCEL 2003, and now that I have EXCEL 2010, it gives me the error message "The information cannot be pasted because the Copy area and the paste area are not the same size and shape"
Nov 21 '11 #1
Share this Question
Share on Google+
3 Replies


GaryTexmo
Expert 100+
P: 1,501
I believe this post is in the wrong section. I'll report it to have it moved :)

That said, I loaded up my Excel 2010 and copied your procedure exactly and didn't get the error. I'm sorry, I'm not sure what else to tell you... does your row contain data in every column, or just some?
Nov 22 '11 #2

NeoPa
Expert Mod 15k+
P: 31,712
I'll look at this when I get the chance Vickie. Must rush now ;-)
Nov 22 '11 #3

NeoPa
Expert Mod 15k+
P: 31,712
What occurs to me from thinking about the error message is that 2003 was the last version with limits of 65536 rows and 256 columns. Are you copying from a workbook that was created in 2003 format, and to a new workbook in 2010 format by any chance? That way the size of the Row object you copied would be different from the size of the Row object you're trying to copy it into.

To get around this you would either :
  1. Save the old file in 2010 format first, then do the same as before.
  2. Copy the actual cells required (rather than the whole row) and insert them into the new workbook as a group of cells.
Nov 23 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.