Manually editing Sort function in VBA
I Have beem attempting to manually do my own sorting in VBA, but to no
avail. So I record a macro that sorts, and that works fine. BUT, if I want
to edit it, it no longer works, also, If I manually type the EXACT same
arguement , it doesnt work. The only thing that works so far in VBA, is just
running the macro and cutting it and pasting it to my macro.
Here is what excel records
Rows("1:11").Select
Selection.Sort Key1:=Range("A2"), Order1:=xlDescending, Key2:=Range("B2") _
, Order2:=xlDescending, Header:=xlYes, OrderCustom:=1,
MatchCase:=False _
, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal,
DataOption2:= _
xlSortNormal
|