View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
Frans van Zelm Frans van Zelm is offline
external usenet poster
 
Posts: 10
Default Sort - OrderCustom

Hi programmers,

In Excel 2K
Selection.Sort ... OrderCustom:=xx
seems to work only using the number of a custom list. But how to be sure of
this number on any other computer then your own?
I tried to refere a range on a sheet, to create and use a (matrix) variable,
.... No go.
The only way seems to be to add the custom list, find the number and use it.

A kiss for a smart solution ;-).

Frans