Hello!
Does anyone understand why I cannot feed this a variable? I have tired using both a string and an integer, but it only works if I hardcode the value, "4", for example. Why!?
Here is the code...
CustomOrder:="3" ---- "3" is where I want the variable so it is dynamic...
Please Login or Register to view this content.
The argument CustomOrder is a Variant type. The Microsoft documentation on this is really poor. What I've been able to glean is that it requires a Variant array. I believe that when you use "4" or "3" VBA automatically casts that to an array of one element.
Just as an educated guess, if you have a variable try this:
You may also find this link informative.Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hello ericbartha,
I don't have Excel 2016 but I doubt there has been any change to this property since the 2013 release.
The CustomSort list contains both built-in and added lists. List 3 is a built-in list of short month names: Jan, Feb, Mar, etc. There should be no problem sorting even if the data in column "A" are note dates. The index should be an integer type (Short or Long) or Variant Integer or Variant Long. This is the offset into the CustomSort array of values.
VBA problems related to compilation are generally caused by Registry fragmentation. You should defrag the registry. This requires third party software since it is not provided as part of the Office suite or Windows operating system.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks guys!
So feeding it the Variant Array as @6StringJazzer suggested did not work, but that suggestion in combonation with a bit of info from the link he provided did.
What I am trying to sort by is an Integer. I convert the integer to a string using Format( , "@") and then use CVar(newString) for CustomOrder:=.
I do not get why this convert works but feeding it a variant directly does not.
Thanks to both of you. Here is the final code:
For a little context, the reason I needed this to work is because I have a dynamic named range that is used to populate the RowSource on a listbox.Please Login or Register to view this content.
I do this by using: =OFFSET(table_ticketUpdates!$A$1,1,1,COUNTIFS(table_ticketUpdates!$A:$A,table_ticketUpdates!$A$2),2) in the Name Manager.
Now, when the user makes their selection, it sorts the table by this info, so only their selection is then returned to the listbox. There might be an easier way to do this, but I think it is pretty slick.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks