Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sorting in Excel
I have tried to sort some data in Excel using the menu and from inside QM using a range and the sort command. The sort command wants 15 arguments and I think I had them all, but when I try it I get a Sort method of Range Class failed. There has to be a better way then using keystrokes to do this. Please let me know what I am missing.

Here is the one thing I tried (I did set the variables used before calling this line).

r1.sort(Key1 Order1 Key2 Type Order2 Key3 Order3 Header OrderCustom MatchCase Orientation SortMethod DataOption1 DataOption2 DataOption3)

Thanks as always.

Forum Jump:

Users browsing this thread: 1 Guest(s)