07-28-2005, 05:13 PM
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.
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.