How about a formula?

Say data A1 to J1.

Enter this *anywhere*, and drag across 10 columns:

=INDEX($A1:$J1,COLUMNS(A:$J))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Swerd" wrote in message
...
I am using excel 2002. I want copy and paste a row. But I want to paste this
inverted which last cell on the original copy becomes the first in the new
copy.