Custom List Number

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

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
 
On way would be to loop through the list and examine each list while
maintaining the count. When you find yours, store the number.
 
Back
Top