Sort current range by column j

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

After the following macro, I want to sort the selected range by column
J.

Sub Macro1()

Range("A100000").Select
Selection.End(xlUp).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlUp)).Select

End Sub
 
After the following macro, I want to sort the selected range by column
Click to expand...

use this:

Selection.Sort Key1:=Range("J3"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom,
DataOption1:=xlSortNormal


good luck
 
Back
Top