Thanks Tt did the trick!
oldjay

"Jim Cone" wrote:


Something to try...
Add a header row and header column with consecutive numbers in them.
Sort the data Right to Left - descending - using the header row as the key.
Sort the data Top to Bottom descending - using the header column as the key.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Oldjay"
wrote in message
I have a range of cells with misc. data Say a1:r10
I wish to rearrange them so that the value in r10 becomes the value ina1and
so on
oldjay