View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott[_6_] scott[_6_] is offline
external usenet poster
 
Posts: 3
Default Custom List Number

I created a macro that adds a custom list to a user's computer.
Another part of the spreadhseet references the list by a number:

(election.Sort Order1:=xlAscending, Type:=xlSortLabels,
OrderCustom:=6, _
Orientation:=xlTopToBottom).

Does anyone know how to grap the custom list number after it is
entered so i can put it into a variable. I am afriad that list #6 for
example may not be the same for everyone else. Thanks.

-Scott