Does anyone know if there a way to do the following:

A1 B1 C1
1 2 3

Copy the values from A1 to C1 onto the clipboard then starting at C1 paste
as follows:

A1 B1 C1
3 2 1

Thanks in advance!

Sarah

I just recorded this. which can then be cleaned up

Sub Macro9()
'
' Macro9 Macro
' Macro recorded 12/11/2006 by Don Guillett
'

'
Columns("C:C").Select
Selection.Cut
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Columns("C:C").Select
Selection.Cut
Columns("B:B").Select
Selection.Insert Shift:=xlToRight
End Sub


Columns("C").Cut
Columns("A").Insert Shift:=xlToRight
Columns("C").Cut
columns("B").Insert Shift:=xlToRight




--
Don Guillett
SalesAid Software

"Sarah" wrote in message
...
Does anyone know if there a way to do the following:

A1 B1 C1
1 2 3

Copy the values from A1 to C1 onto the clipboard then starting at C1 paste
as follows:

A1 B1 C1
3 2 1

Thanks in advance!

Sarah

Sarah

Not without some VBA code.

I would select just the three cells then DataSortOptionsSort left to Right in
descending order.


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 09:51:11 -0800, Sarah
wrote:

Does anyone know if there a way to do the following:

A1 B1 C1
1 2 3

Copy the values from A1 to C1 onto the clipboard then starting at C1 paste
as follows:

A1 B1 C1
3 2 1

Thanks in advance!

Sarah