Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sorting in Excel
#1
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=ex1.range("a1:h113")
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)