Tanspose Error
 

Excel 2003. I recieve this error when i am transposing: "the information
cannot be pasted because the copy area and the paste area are not the same
size and shape"
I think that it might be related to the amount of cells because when i
transpose a portion of the spreadsheet its fine. The error description is
what is confusing myself. Any ideas.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200810/1

Tanspose Error
 

You cannot transpose more rows than there are columns if that's what you're
trying to do.

i.e. Excel 2003 has 256 columns so you cannot transpose 257 rows.


Gord Dibben MS Excel MVP

On Wed, 08 Oct 2008 17:05:36 GMT, "rtwiss via OfficeKB.com" <u46610@uwe
wrote:

Excel 2003. I recieve this error when i am transposing: "the information
cannot be pasted because the copy area and the paste area are not the same
size and shape"
I think that it might be related to the amount of cells because when i
transpose a portion of the spreadsheet its fine. The error description is
what is confusing myself. Any ideas.

Tanspose Error
 

Thanks

Gord Dibben wrote:
You cannot transpose more rows than there are columns if that's what you're
trying to do.

i.e. Excel 2003 has 256 columns so you cannot transpose 257 rows.

Gord Dibben MS Excel MVP

Excel 2003. I recieve this error when i am transposing: "the information
cannot be pasted because the copy area and the paste area are not the same
size and shape"
I think that it might be related to the amount of cells because when i
transpose a portion of the spreadsheet its fine. The error description is
what is confusing myself. Any ideas.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200810/1