If you want to stay on the same sheet you have to ensure the copied range
and the pasted range do not overlap.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Peo Sjoblom" wrote in message
...
If you have less than 256 rows, copy the data, go to a new sheet and do
editpaste special and select transpose
If you have more than 256 rows it can't be done, then you need to put it
on
multiple sheets since excel only have 256 columns



--

Regards,

Peo Sjoblom

"Larry Heine" <Larry wrote in message
...
I been building a spreadsheet to record data and would like to
interchange
the rows and columns to make viewing easier (I want to make the row data
become column data and the column data become row data).

Thanks!