Excel 2010: Move Block

[Vickie Easton]

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"

[GaryTexmo]

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?

[NeoPa]

I'll look at this when I get the chance Vickie. Must rush now ;-)

[NeoPa]

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.