LinkBack URL
About LinkBacks
I am getting "Named argument not found" error while sorting using multiple keys.
However, the code works fine when a single "Key" is defined. But gives error if "Key1" is used.
Please Login or Register to view this content.
I am getting "Named argument not found" error while sorting using multiple keys.
However, the code works fine when a single "Key" is defined. But gives error if "Key1" is used.Please Login or Register to view this content.
You are mixing the range sort method from XL2003- with the worksheet sort method from XL2007+. Before, you could only use three keys, now you can add more (not sure of the limit) but you add them one by one, so try it this way:
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 08-21-2015 at 12:53 PM.
Bernie Deitrick
Excel MVP 2000-2010
Thanks Bernie. That worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks