Thread: Sort an array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Sort an array

somerange.Sort does an excellent job of sorting data on a worksheet.
What is the equivalent function or method to sort the elements of an array?

(I am currently copying the array to un-used cells on a worksheet, sorting
the cells, and then copying the data back to the array. This is less code
than using a shell or buble sort, but it can't be optimal.)
--
Gary''s Student