Basically, you have it right, you need to add it, then sort on the new
number

OrderCustom:=Application.CustomListCount

But guess what, there is a problem. See this article

http://support.microsoft.com/default.aspx?kbid=134913
XL: GetCustomListNum Returns Unexpected List Number

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frans van Zelm" wrote in message
...
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