I am trying to sort a sheet alpahbetically From a Column and I want
all of the adjoin values and text from a row to move with it

can this be done

Painter

"Painter" wrote:

I am trying to sort a sheet alpahbetically From a Column and I want
all of the adjoin values and text from a row to move with it

can this be done

Painter

Sub Macro1()
'
' Macro1 Macro
'
'

'
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

I just used data, sort , column a on the menu bar and recorded it as a macro.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 1/31/2006 by Paymentech
'

'
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub


"Painter" wrote:

I am trying to sort a sheet alpahbetically From a Column and I want
all of the adjoin values and text from a row to move with it

can this be done

Painter