View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Custom List Number

On way would be to loop through the list and examine each list while
maintaining the count. When you find yours, store the number.

--
Regards,
Tom Ogilvy

"scott" wrote in message
om...
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