View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Modify Claus code "Sub Array_Var_Column_Sort()"

Hi Garry,

Am Fri, 22 Aug 2014 15:30:09 -0400 schrieb GS:

Another issue is that even though your code sets the range,
Sheet.Sort applies to the entire sheet as opposed to just the area
defined in .SetRange!!!


in the newer version you can add 64 sort keys. But the syntax to do
so brings the disadvantages you found.


Regards
Claus B.


Thanks! I've been reading up on this and don't see any reason to change
from how I do data sorting now. Maybe I need to play with it some
more...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion