The following warnings occurred:
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 895 - File: showthread.php PHP 7.2.34 (Linux)
File Line Function
/showthread.php 895 errorHandler->error

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.

Messages In This Thread

Forum Jump:

Users browsing this thread: 1 Guest(s)