Help for this page

Select Code to Download


  1. or download this
    Columns("M:N").Select
        Selection.Sort Key1:=Range("M2"), Order1:=xlAscending, Header:=xlY
    +es, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, 
    +_
            DataOption1:=xlSortNormal
    
  2. or download this
    $Range_new1 = $Sheet->Range("m2");
    $Range_new2 = $Sheet->Range("n2");
    ...
                OrderCustom=>1,
                MatchCase => False,
                DataOption1 => xlSortNormal});
    
  3. or download this
    $Range_new1 = $Sheet->Range("m:n");
    $Range_new2 = $Sheet->Range("n2");
    ...
                             OrderCustom=>1,
                             MatchCase => False,
                             DataOption1 => xlSortNormal});