Hi,
I am trying to make a Generic Script Maker, and would like to sort the scripts in ascending order by the Sequence column. ( So basically numerical values are to be inserted in Sequence. I am encountering "Select Method of class Range Failed." when using the
Code
Range("A1:D1").Select Selection.Sort Key1:=Range("E2"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Attached also is the Workbook. forum.ozgrid.com/index.php?attachment/70016/
Any help is appreciated.
Regards,
Mot