Hi Garry,
Am Fri, 22 Aug 2014 13:08:13 -0400 schrieb GS:
Bummer that Sort *still* doesn't work well with numeric sequencing!!
.Sort.SortFields.Add Key:=.Range(varKey(i)) _
, SortOn:=xlSortOnValues, Order:=xlDescending
delete SortOn:=xlSortOnValues
Then most of the times Sort works well
If not, please send me your example
Regards
Claus B.
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!!!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion